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;