ICEcoffee Posted June 29, 2006 Share Posted June 29, 2006 Hi allI have imported a table from an ODBC database into MySQL, but all the data in all the columns are surounded by quotation marks.Can anyone tell me how to write a query I can execute, to update all fields, to delete said quotation marks.Thanks for any help, it will save me hours of work. Link to comment https://forums.phpfreaks.com/topic/13197-update-query/ Share on other sites More sharing options...
Wildbug Posted June 30, 2006 Share Posted June 30, 2006 Do you have a "dumped" database in a text file? Can you write a perl script (w/ a regular expression) to excise the quotes? (Then reimport the data....)Actually this might be easier...:If you already have the data in the database, you can use something like the following:[code]UPDATE mytable SET mytextcolumn1=TRIM(BOTH '"' FROM mytextcolumn1),mytextcolumn2=TRIM(BOTH '"' FROM mytextcolumn2);[/code] Link to comment https://forums.phpfreaks.com/topic/13197-update-query/#findComment-51367 Share on other sites More sharing options...
Barand Posted July 1, 2006 Share Posted July 1, 2006 Dump the data from ODBC DB into a csv file.Use Mysql LOAD DATA INFILE to load the data and specify that quotes are used. Link to comment https://forums.phpfreaks.com/topic/13197-update-query/#findComment-51479 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.