Menu
I have a big table in the database with tags. Not all the words have Latin characters (English, French ...), some words have non-Latin characters (Hebrew, Persian, Arabic ...)
How can I select the words ORDER BY [Language of word] ?
542
MySQL Order By specific strings? Order by the choice of strings you want, using the FIELD () function. The syntax is as follows − SELECT *FROM yourTableName ORDER BY FIELD (yourColumnName,’yourValue1’, ’yourValue2’,’yourValue3’,....N);
The ORDER BY clause allows you to sort data using a custom list by using the FIELD () function. See the following orders table from the sample database. Suppose that you want to sort the sales orders based on their statuses in the following order:
Summary: in this tutorial, you will learn about some natural sorting techniques in MySQL using the ORDER BY clause. First, create a new table named items by using the following CREATE TABLE statement: Third, query data from the items table sorted by the item_no: This may not what we expected. We expect to see the result like the following picture:
We are used to sort both numeric and string values either in ascending or descending manner. But by default, it sorts in ascending manner. If we want to descend, then we need to specify it after using the ORDER BY clause.
You could define a second table languages, then attach a language tag to each entry. You can add a sort order column to the languages table, then when you select, join against the languages table and order by the tag field, then by the language sort order.
120
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
