MySql Update LIKE %...%

iNod · 03-11-2008, 06:17 PM

Hello All,

I am looking for a mysql statement that would allow me to update a particular section of a mysql field. For example

"Hello,

FGjgkg
Gkfdgjhgkf

Gjkfgjk

<a href="gjgfkfg.com">GJHGDfg</a>

Cheetoss
"

I would like to change <a href="blah.com">gfjdgk</a> to GFHGDfg

Is this possible? Even if I have to run one sql statement 4 times for each part. (change <a href=" to [url=" for the first one, and so on)

- Steve

**Eric** · 03-11-2008, 06:27 PM

Possibly http://dev.mysql.com/doc/refman/4.1/...nction_replace

Code:

# REPLACE(str,from_str,to_str)
UPDATE table SET field = REPLACE(field, '<a href="blah.com">gfjdgk</a>', 'GFHGDfg') WHERE id = 1;

If I understand correctly.

03-11-2008, 06:17 PM	#1 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,289 126.05 NP$ (Donate)	MySql Update LIKE %...% Hello All, I am looking for a mysql statement that would allow me to update a particular section of a mysql field. For example "Hello, FGjgkg Gkfdgjhgkf Gjkfgjk <a href="gjgfkfg.com">GJHGDfg</a> Cheetoss " I would like to change <a href="blah.com">gfjdgk</a> to GFHGDfg Is this possible? Even if I have to run one sql statement 4 times for each part. (change <a href=" to [url=" for the first one, and so on) - Steve __________________ I feel old.

03-11-2008, 06:27 PM	#2 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	Possibly http://dev.mysql.com/doc/refman/4.1/...nction_replace Code: # REPLACE(str,from_str,to_str) UPDATE table SET field = REPLACE(field, '<a href="blah.com">gfjdgk</a>', 'GFHGDfg') WHERE id = 1; If I understand correctly. __________________

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Technical Services