[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