jedimastermopar
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?
Just wondering if anyone knows a way I can run a query to strip out commas from a table?
|
||||
Strip invalid char from tablesjedimastermopar 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? Fumigator 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