LinkedInTwitterFacebook

Category Archives: SQL

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

Share

Export the database in phpmyadmin – setting name and filetype.

Always save a backup of your data. An important aspect is the date when the backup was made??. Today I will show you how to format the backup name so you know since you have. Select the database and go to the Export tag and Custom – display all possible options. If you select only […]

Share