...

View Full Version : Strip invalid char from tables



jedimastermopar
02-13-2007, 05:17 PM
Hey guys,
Just wondering if anyone knows a way I can run a query to strip out commas from a table?

Fumigator
02-13-2007, 07:37 PM
You can use the replace() string function and replace ',' with ' '.


UPDATE table_name
SET column_name = replace(column_name, ',', ' ')


Manual reference (http://dev.mysql.com/doc/refman/4.1/en/string-functions.html)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum