MySQL Queries Cheat Sheet

Home > Programming & Technology

The most common MySQL queries are listed in this document. These are the queries that I use mostly and they are my reference when I am writing queries. These are all the queries that you need to know for your MySQL database applications.

Append a Value in a String Column

UPDATE quotes SET tags = CONCAT(col_name,' and append this') WHERE category = 1;

 

If Column is Null

If the field code is NULL by default you need to use:

 

UPDATE table_name SET col = CONCAT(IFNULL(col_name,''), 'and append this') WHERE id = 1;

 

Otherwise the concat will always result in NULL. 

 

Replace a String in a string field

 

UPDATE table_name

SET col = REPLACE(col, 'match', 'replace')

 

For Example,

 

UPDATE articles SET tags = REPLACE(tags, "Top", 'Top 10')

 

This query only replaces the text that matches, so if the string and more than the matched text, the rest of the unmatched text remains intact and is not lost.

Comment Form is loading comments...

Table of contents