clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 462181 distinct fiddles created so far.

CREATE TABLE test (idC VARCHAR(6)) AS SELECT '1/2019' idC UNION ALL SELECT '1/2020' UNION ALL SELECT '2/2019'
 hidden batch(es)


SELECT * FROM test ORDER BY idC
idC
1/2019
1/2020
2/2019
 hidden batch(es)


SELECT * FROM test ORDER BY SUBSTRING_INDEX(idC, '/', -1), SUBSTRING_INDEX(idC, '/', 1)
idC
1/2019
2/2019
1/2020
 hidden batch(es)