I have the following calculated field:
CONCAT(idC, '/', DATE_FORMAT(entryDate, '%Y')) as idC
I have idC stored on database, that's a ''fake'' id that increments based on another field called entryDate, so it's not a unique number.
On the get query I concat that id with the entry date so it returns for example 1/2019, 2/2019, 1/2020...
The problem is that I want that id to be ordered ascending like a 'date' so it should be 1/2019, 2/2019, 1/2020
The order that MySQL returns is 1/2019, 1/2020, 2/2019 because as a string it makes sense to give that answer
Is there any way to make MySQL return the desired order by?