Press "Enter" to skip to content

Advanced ordering of results in MySQL

We can use “LIKE” in ordering the results in MySQL and Maria DB. “LIKE” is an comparision  that performs matching on a per-character basis.

It helps us to sort our results based upon priority.

For example:

Same goes for “NOT LIKE”.

You can also explicitly specify the order of your result like this.

Everything is awesome.