|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
March 22nd, 2004, 10:09 PM
|
|||
|
|||
|
mySQL SELECT and REPLACE
How would I write a mySQL statement the would, for example, select anything in the database that equals robert and replace it with Robert?
|
|
#2
March 22nd, 2004, 10:43 PM
|
|||
|
|||
|
RE: mySQL SELECT and REPLACE
You're not giving a whole lot of info to work with, but on a basic level you could just use UPDATE.
Maybe something like Code:
UPDATE table_name SET first_name='Robert' WHERE first_name='robert';
|
|
#3
March 22nd, 2004, 11:21 PM
|
|||
|
|||
|
RE: mySQL SELECT and REPLACE
I have a database with more tables than I would like to type, that I would like to replace every occurance of certain names.
What I'm looking for is maybe a wildcard of somesort that will replace every value of 'robert' to 'Robert'. I'm sure it sounds lazy and potentially dangerous, but the name occurs in quite a few tables. Thanks for your help though!
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > mySQL SELECT and REPLACE |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
