Sometimes it’s necessary fix data on the database.
I had to fix on a Microsoft database:
/* MSSQL syntax */
update table_links set url = Replace(url, 'www.link.it/web3', 'www.link.it/web') where url <>''
I had to fix on a MySQL database:
/* MySQL syntax is the same! */
UPDATE table_links SET url =REPLACE(url, '&', '&') where url<>''
The syntax is the same.
PHP expert. Wordpress plugin and theme developer. Father, Maker, Arduino and ESP8266 enthusiast.
Use mysql variables to create a counter in SQL, PHP code to use an SQL counter and what does the i mean in mysqli?
If you’ve just switched to FULLTEXT indexes and you’ve just started playing with MATCH... AGAINST syntax, but you always get…
Ok. You’ve added custom fields in wordpress, but how can you remove them? How to delete custom fields wordpress Two…
Here is a list of thirteen tips that can be usefull for your queries. If you know more tips send…
This PHP function search for tables in the active db, match table’s name with the regular expression passed as first…
I’ve modified the previous post to use mysqli instead of mysql. Was it necessary? I think it was good step…
