|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#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
