mysql order-by original "where order"
- by Benjamin Dobnikar
I have this order-by problem I canot crack. I select from my table like this:
SELECT * FROM 'sidemodules' WHERE name = 'module1' OR name = 'module2' OR 'name3'
Which returns me the modules I want. But the modules lie the table, say in this order:
module3
module1
module2
And they are returned to me in this order. How can I get them to display in order AS IN THE WHERE CLAUSE (1,2,3) ?
Big thanks!