<p>I have to sort a list of categories using MySQL as I am using a CMS that only allows this. Is there a way to sort alphabetically but to return one entry ("Other") at the end of the list?</p>

<p><code>ORDER BY ColumnName = 'Other', ColumnName</code></p>

MySQL - ordering alphabetically except for one entry?

ORDER BY ColumnName = 'Other', ColumnName

194

answered Dec 10 '22 13:12

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!