[Bug 53657] Natural version sort

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=53657

--- Comment #9 from Joerg Schiermeier <mywine(a)schiermeier-it.de> ---
For MariaDB this SQL will do the trick (as Artem correctly wrote):

SELECT Version FROM app ORDER BY NATURAL_SORT_KEY(Version);

See:
https://sqlfiddle.com/mariadb/online-compiler?id=7b10cc17-4794-4b22-9198-b2b...

For MySQL, a stored function is better:

See:
https://stackoverflow.com/a/12257917

-- 
Do not reply to this email, post in Bugzilla using the
above URL to reply.
You are receiving this mail because:
You are watching all bug changes.