How to sort alphabetically the data (in the presence of quotes)?

Question

MySQL

There is data in the MySQL database.
I want to sort alphabetically (name ASC). But those entries that have quotes at the beginning and at the end ("Expo"), they are sorted first, and should be sorted by the first letter.
How to solve the problem?

Answer 1

Please note that IceJOKER and Mikhail Toderashko 's solution will work VERY slowly on even a relatively small base.
This sort does not use indexes.
With each request, for each row, the value of the TRIM function will be calculated, and then also sorted.
The correct solution in my opinion is to update the name field so that there are no quotes in it.
If this is not possible, create a new field without quotes and sort by it.

Answer 2

ORDER BY TRIM(BOTH '"' FROM name);
stackoverflow.com/questions/1439965/sort-by-name-b...

Answer 3

Try:

SELECT * FROM `table` ORDER BY TRIM(BOTH '"' FROM `name`)

Answer 4

You need to use linguistic sorting. If you can do something like alter session set NLS_SORT = LINGUISTIC in MySQL, as in another Oracle database, this should be the solution. I suggest reading the MySQL documentation.