TranHaiQuan/Note.md

Last active August 21, 2019 04:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

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

Download ZIP

Sort kết hợp 1 trong 2 field null, sử dụng select if or select IFNULL

Raw

Note.md

SELECT IF https://www.w3resource.com/mysql/control-flow-functions/if-function.php

SELECT IF(A IS NULL, B, A) AS AB from table_name order AB ASC

SELECT IFNULL

SELECT IFNULL(A,B) AS AB from table_name order AB ASC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment