[SOLVED] Wildcard updates?

[Cless]

With MySQL, is it possible to do a wildcard set? For example, when using search, you can say:

 

SELECT * FROM blah WHERE b_moo LIKE '%2%'

 

...which would select all rows where b_moo has the number 2 in it.

 

I need to do something similar in an UPDATE query, similar to:

 

UPDATE blah SET b_moo='%3%' WHERE b_moo LIKE '%2%'

 

...which I want to replace all instances of the number 2 with 3 (or, atleast, the first instance).

 

Is this possible?

 

Thanks!

[waynew]

Have you tried it?

[Cless]

Yeah, it just sets it to "%3%". xD

[Mark Baker]

UPDATE blah SET b_moo=REPLACE(b_moo,'2','3') WHERE b_moo LIKE '%2%'

 

[Cless]

Thanks! 8D