Mysql tricks

mysql_tricks.md

MySql fetch data by conditional order

Suppose, You want to search product with specified key and the products with stock should appear first in the search result.

SELECT * FROM `products` WHERE name LIKE 'na%'
ORDER BY CASE
    WHEN id IN (602, 603, 18125) THEN 1
    ELSE 2
END, name ASC

Add Virtual field

//add p_type as virtual field
SELECT name, 'mahbub' as p_type from products