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

How to perform case insensitive ORDER BY in mysql?

Tags:

mysql

I want to perform case-insensitive ORDER BY in MySQL. I have the data in my database like A, C, b, e, D etc

I'm getting the result as A, C, D, b, e

But, I want the result as A, b, C, D, e

How can I get that?

like image 944
Manikandan C Avatar asked Jan 10 '18 13:01

Manikandan C

People also ask

How do I create a case-insensitive query in MySQL?

If you want case-insensitive distinct, you need to use UPPER() or LOWER().

Is MySQL ORDER BY case-sensitive?

MySQL by default will make the ORDER BY option in queries case sensitive. This means that rows with the same starting letters (but different case) may be ordered non-alphabetically.

Is SQL ORDER BY case-sensitive?

SQL Server is, by default, case insensitive; however, it is possible to create a case-sensitive SQL Server database and even to make specific table columns case sensitive. The way to determine if a database or database object is to check its "COLLATION" property and look for "CI" or "CS" in the result.

Is MySQL case-insensitive by default?

Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.

1 Answers

Choose a case-insensitive collation

select * from your_table
order by your_column COLLATE utf8_general_ci

That way indexes still work and the query is fast.

like image 188
juergen d Avatar answered Nov 15 '22 20:11

juergen d
Sign in to Comment

Related questions

How to update a view in phpMyAdmin?
Easy way of generating a slug name column from the name column?
How to log query and its execution time of each query which runs on a db?
How to write a query with join, update and order by?
MySQL password() function to PHP
MYSQL Select MAX Date inside a join statement
Django group by dates and SUM values [duplicate]
Mysql datetime format add 10 minutes
Sails.js Waterline query modifiers for dates with sails-mysql?
Docker and Mysql: libz.so.1: cannot open shared object file: Permission denied
WordPress Meta-Query between 2 dates
Laravel Eloquent with()-> returning null
Where is Oracle sqlplus located?
Why is an IX-lock compatible with another IX-lock in InnoDB?
Entity Framework MySQL tinyint(1) System.Boolean.Parse FormatException
How do I correctly set ownership and privileges in MariaDB (MySQL)?
HikariCP Connection Pool immediately creates 100 connections
(MySQL) Load data infile specific columns
Mysql 5.7 ERROR 3143 (42000): Invalid JSON path expression. The error is around character position 3
Error setting up MySQL: Table 'mysql.plugin' doesn't exist

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!