Category Archives: SQL Databases

Fix error: mysql error 1140 (42000).

This query will fix the error mysql error 1140 (42000).

Replace words in the fields of table using SQL.

If you trying to apply a global text string with an replace , than use this:

The your_sql_table is the name of the table. The field_from_your_sql_table is the field with records where will be find and repleced words. The wrong_word is the word search and replace by good_word