This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Find and Replace script
#3
(10.01.2020, 12:48)admin Wrote: Use direct db queries (db:update), there's no point in grp.create here. Don't forget to add `id` to SELECT fields.
If you only need to match beginning of the name you can omit the first %. You can also use one LIKE statement instead of two.

I am not sure how to phrase the update in the SQL statement. How do I state what should be replaced with what?
There are 10 kinds of people in the world; those who can read binary and those who don't  Cool
Reply


Messages In This Thread
Find and Replace script - by Trond Hoyem - 10.01.2020, 10:52
RE: Find and Replace script - by admin - 10.01.2020, 12:48
RE: Find and Replace script - by Trond Hoyem - 10.01.2020, 13:06
RE: Find and Replace script - by admin - 10.01.2020, 13:35
RE: Find and Replace script - by Trond Hoyem - 10.01.2020, 13:53
RE: Find and Replace script - by admin - 10.01.2020, 14:06
RE: Find and Replace script - by Trond Hoyem - 10.01.2020, 14:10

Forum Jump: