I'm not even sure if this is possible, but here is the scenario:
- I have a table called dir_websites
- In that table, I have a field/column called "url"
Now this table is filled with entries that have a similar URL containing "folderA" in it. For example:
I want to change all the entries in the table that has the "folderA" in it's url to not contain the "folderA" part in their url. For example:
Basically the website moved it's development website in the /folderA/ folder, to the live website on root. However all the urls were hardcoded with /folderA/ in the database table.
There are over 280 entries in the table.
I don't need the PHP version because I would like to just run the sql statement in phpmyadmin.
Is something like the above possible or am I out of luck?
Thank you in advance.
SET url = CONCAT('http://www.mywebsite.com/', SUBSTR(url, 33))
WHERE url LIKE 'http://www.mywebsite.com/folderA/%'