[Bug 53657] Natural version sort

[WineHQ Bugzilla]

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

--- Comment #1 from Artem S. Tashkinov  ---
If you're using MariaDB 10.7 or higher, then:

https://gitlab.winehq.org/winehq/appdb/-/blob/master/include/application.php

Line 118:

$sQuery = "SELECT versionId FROM appVersion WHERE
                appId = '?'$sExtraTerms ORDER by versionName";

Should become

$sQuery = "SELECT versionId FROM appVersion WHERE
                appId = '?'$sExtraTerms ORDER by NATURAL_SORT_KEY(versionName);

No idea how to do that in MySQL.

This solution may not work:
https://www.copterlabs.com/natural-sorting-in-mysql/

Maybe you could use PHP's natsort()  instead.