about catalogue sorting

[Phonograph]

if you want catalogues to be sorted in natural order when you click the link to sort them
here's the sql (<catalog> if the keyword from the search)

SELECT catalog, SUBSTRING_INDEX(catalog, '-', -1) AS cn FROM `<database>`
WHERE catalog LIKE '<catalog>%' ORDER BY cn ASC

like that instead of having
KICA-1
KICA-1001
KICA-108

you will have
KICA-1
KICA-108
KICA-1001