mrabbani/mysql_tricks.md

## mysql_tricks.md

      
    Raw
  

              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