Quote:
|
Originally Posted by dennispopel
Hello,
Try ORDER BY persID
|
the results are being sorted as if he used that.. but he does NOT want that!
he wants the order to be as provided in the IN() ..
I've tried similar query here and it's also sorting it in ascending order.I am not sure why it's behaving like this..
edit: UNION is only for MySQL 4.x and above.. and I guess they would be slow..
also, if you are having one value why use IN() ?