mysql find and replace
Posted: Tue Sep 18, 2007 2:46 am
I wanted to convert a excel file to csv so i can import it to mysql but it has comers in it (,) so i replaced them with # and now im trying to run this query in mysql query browser to change them back to a coma
Can anyone tell me where im going wrong?
Thanks
Clint
Code: Select all
update `newprice list` set `newprice list`.Description =
replace([field_name],'[#]','[,]');Thanks
Clint