Does anyone know if it is possible to replace all occurences of a charachter in all of the SQL database entries? For example;
a needs to be replaced with b in field 1, 2 3,4 and 5.
d needs to be replaced with c in field 1, 2 3,4 and 5.
I've had a look through the MySQL docs, but I'm a little lost. I understand the LIKE % stuff, but can't see if/how its possible to do what I'm looking for
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
a needs to be replaced with b in field 1, 2 3,4 and 5.
d needs to be replaced with c in field 1, 2 3,4 and 5.
I've had a look through the MySQL docs, but I'm a little lost. I understand the LIKE % stuff, but can't see if/how its possible to do what I'm looking for
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Replace certain charachters in ALL fields?