UPDATE sales_flat_order_address1 SET `street1` = LEFT( `street` , LOCATE('\n', `street` )) WHERE LOCATE('\n', `street` )>1
SELECT *, LOCATE('\n', `street` )AS a
FROM sales_flat_order_address1
HAVING a >1
LIMIT 0,30
UPDATE sales_flat_order_address1 SET `street1` = LEFT(`street1`,LOCATE('\n',`street`)-1) WHERE LOCATE('\n',`street`)>1 AND entity_id=598476;
UPDATE sales_flat_order_address1 SET `street2` = RIGHT(`street`,LENGTH(`street`)-LOCATE('\n',`street`)) WHERE LOCATE('\n',`street`)>1;
UPDATE sales_flat_order_address1 SET `street2` = RIGHT(`street`,LENGTH(`street`)-LOCATE('\n',`street`)) WHERE LOCATE('\n',`street`)>1;
UPDATE sales_flat_order_address1 SET `street1` = LEFT(`street`,LOCATE('\n',`street`)) WHERE LOCATE('\n',`street`)>1;
SELECT entity_id, LENGTH(`street`),RIGHT(`street`,LENGTH(`street`)-LOCATE('\n',`street`)), LOCATE('\n',`street`)as a FROM sales_flat_order_address1 having a>1
SELECT entity_id, LENGTH(`street`),RIGHT(`street`,LENGTH(`street`)-LOCATE('\n',`street`)), LOCATE('\n',`street`)as a FROM sales_flat_order_address1 having a>1
UPDATE sales_flat_order_address1 SET `street2` = RIGHT (street, LENGTH(`street`)-LOCATE('\n',`street`));
SELECT LEFT(`street`,LENGTH(`street`)-LOCATE('\n',`street`)) FROM sales_flat_order_address1;
Loading...