|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 24th, 2003, 03:55 AM
|
|||
|
|||
|
MySQL and rubbish in fields
Hello everyone!
I'm having a problem here: I have an access database with some fields filled with "%"s, "$"s and "<BR>"s. I've been successful at exporting everything to mysql, but I was wondering how I could remove all that %$<br> stuff, maybe replacing it by spaces or even by nothing. Is there a function in mysql that enables you to do that, or am I better off coding a php script that will SELECT *, remove the stuff, and UPDATE again? This solution seems a bit overkill... But I couldn't find anything in the MySQL manual about replacing chars in strings. Thanks a lot, Jean-Marie
|
|
#2
July 24th, 2003, 04:24 AM
|
||||
|
||||
|
First, as this is a MySQL specific question, why didn't you post it to the specific forum??
Then, you didn't search well, the answer is at http://www.mysql.com/doc/en/String_functions.html (replace).
|
|
#3
July 24th, 2003, 04:30 AM
|
|||
|
|||
|
sorry for the wrong forum, my intention was to post the message with the access database... Thanks for the answer, I would never have thought of SELECTing to UPDATE, that's why I dind't even read that part.
Thanks again!
|
|
#4
July 24th, 2003, 04:30 AM
|
||||
|
||||
|
write a script, it's not overkill.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > MySQL and rubbish in fields |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
