[Phpwm] mysql search / replace

David Goodwin david at codepoets.co.uk
Mon Oct 8 09:36:06 BST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Phil Beynon wrote:
> Using;
> 
> UPDATE tablename SET fieldname = REPLACE(fieldname, 'existing
> text','replacement text')
> 
> is there a way of setting a single char wildcard in 'existing text'?


Does MySQL support regular expressions? (Presumably yes...)


- --
David Goodwin

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHCevX/ISo3RF5V6YRAnVqAJ4mNlAq8+nxfZznu6f/NZ9Vc0XWFwCfVxVL
v1fLr9L/GVJVpn8qYr6vY3o=
=kJ/k
-----END PGP SIGNATURE-----



More information about the Phpwm mailing list