Go Back   CodingForums.com > :: Server side development > MySQL
Reload this Page Strip invalid char from tables

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 02-13-2007, 04:17 PM   PM User | #1
jedimastermopar
Regular Coder

 
Join Date: Nov 2006
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
jedimastermopar is an unknown quantity at this point
Strip invalid char from tables
Hey guys,
Just wondering if anyone knows a way I can run a query to strip out commas from a table?
jedimastermopar is offline   Reply With Quote
Old 02-13-2007, 06:37 PM   PM User | #2
Fumigator
UE Antagonizer


 
Fumigator's Avatar
 
Join Date: Dec 2005
Location: Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
Posts: 7,686
Thanks: 42
Thanked 637 Times in 625 Posts
Fumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of light
You can use the replace() string function and replace ',' with ' '.
Code:
UPDATE table_name
SET column_name = replace(column_name, ',', ' ')
Manual reference
__________________
Fumigator is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:48 PM.
Advertisement
Log in to turn off these ads.