Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL - ordering alphabetically except for one entry?

Tags:

mysql

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?

like image 589
bcoughlan Avatar asked Dec 07 '22 02:12

bcoughlan

1 Answers

ORDER BY ColumnName = 'Other', ColumnName

like image 194
Hammerite Avatar answered Dec 10 '22 13:12

Hammerite
Sign in to Comment

Related questions

Determining unread items in a forum
Calculated Column Based on Two Calculated Columns
MySQL to get the count of rows that fall on a date for each day of a month
Getting to know a new web-system that you have to work on/extend
MySQL Select Where First Character Is
Why does my InnoDB table have a weird value for record count?
Concatenating records in a single column without looping?
What else should I be doing to sanitize user input?
MySQL Query to find customers who have ordered two specific products
Can Django models use MySQL functions?
Getting row data of inserted row (Mysql, PHP, mysqli)
Get domain from URL to GROUP BY using MySQL
How to store the object data in mysql db using php class function?
How to repair a MySQL table without using phpMyAdmin?
How to do this in MySQL: if field value > 0 then minus one, else let it be
How can I save an image from a file input field using PHP & MySQL?
Get data from table from a list of strings on MySQL
Importing old mysql data folder
mysql: group by ID, get highest priority per each ID
Reading UTF-8 data from MySQL shows ? instead of ı

Donate For Us

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