Sort text field as numbers and as strings simultaneously in MySQL
The database has a text field, the data from which you want to display in alphabetical order, if the data is text, or sort as numbers, if the data are numbers.
Example of required sorting: 8, 9, 10, 11, 12, Android 2.2, Android 2.3, BlackBerry
I needed this sorting when developing a product filter for one store engine (I refer to it, consider advertising), which can contain both textual and numeric data (and sometimes both at the same time as in the example).
')
Google brought only some terrible triggers and regexps.
I suggest you offer your solution.
My solution (select text to peek):
ORDER BY value = 0, -value DESC, value
Example of required sorting: 8, 9, 10, 11, 12, Android 2.2, Android 2.3, BlackBerry
I needed this sorting when developing a product filter for one store engine (I refer to it, consider advertising), which can contain both textual and numeric data (and sometimes both at the same time as in the example).
')
Google brought only some terrible triggers and regexps.
I suggest you offer your solution.
My solution (select text to peek):
ORDER BY value = 0, -value DESC, value
Source: https://habr.com/ru/post/139159/
All Articles