UPDATEing a MySQL SET where values contain commas
Posted: Fri Oct 22, 2004 7:16 pm
Hey guys -
Can someone help me out here?
I know how to extract and form a SQL query to update a SET in SQL that contains regular values, such as `var` = 'one,two,three', but what do you do when one of the values has a comma in it:
`var` = '$10,000,$20,000,$30,000'
That's obviously wrong. I tried \, and it didn't work either.
Thanks,
Peter.
Can someone help me out here?
I know how to extract and form a SQL query to update a SET in SQL that contains regular values, such as `var` = 'one,two,three', but what do you do when one of the values has a comma in it:
`var` = '$10,000,$20,000,$30,000'
That's obviously wrong. I tried \, and it didn't work either.
Thanks,
Peter.