sort by matched one mysql code example

Example: sort by myqsl

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESCl;