mrabbani/mysql_tricks.md

Last active November 5, 2019 05:39

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mrabbani/2092fae872a5c6fd915cf02541d0d01f.js"></script>
Save mrabbani/2092fae872a5c6fd915cf02541d0d01f to your computer and use it in GitHub Desktop.

Mysql tricks

Raw

Prority Search

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