View Full Version : Strip invalid char from tables

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

02-13-2007, 06: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