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.
Same goes for “NOT LIKE”.
You can also explicitly specify the order of your result like this.
Everything is awesome.