469,623 Members | 1,111 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

'UPDATE' in MySQL

Is there a way to replace part of a string with a wildcard - i.e...

"*lodges" with "*Lodges"

and also to be able to remove a space - i.e . .

" houses" with "houses".

??
Thanks,
Martin
Jul 26 '06 #1
1 1950
iam_clint
1,208 Expert 1GB
i don't believe you can do what your wanting without doing a mass update through some sort of script.
Jul 26 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Reply via newsgroup | last post: by
reply views Thread by Peter Fleck | last post: by
reply views Thread by Fraser Hanson | last post: by
reply views Thread by Steven Hilton | last post: by
5 posts views Thread by jayson_13 | last post: by
2 posts views Thread by Carlos Eduardo Peralta | last post: by
17 posts views Thread by kalamos | last post: by
7 posts views Thread by sime | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.