samedi 27 juin 2015

ordering sql results from IN() function

I have a query:

SELECT categories_id
     , categories_name
     ,categories_url
FROM categories
WHERE categories_id IN(0,72,51,52)

For the IN function I have the numbers 0,72,51,52, but when I get the sql results they are 0,51,52,72, i.e. chronological. How can I order them the same way there were originally as 0,72,51,52?

Aucun commentaire:

Enregistrer un commentaire