Display Ads On This Blog

Banner Ads on scriptforphp.blogspot.com
Provides free php script for php developer.
Prix: € 5.00

Wednesday, June 10, 2009

how to order mysql query via input order in an IN() clause

SELECT *
FROM `articles`
WHERE article_id
IN ( 31, 27, 36, 23 )
ORDER BY FIND_IN_SET(
article_id,'31,27,36,23' )
LIMIT 0 , 30

1 comments:

  1. This is a must read blog. The technical help presented on this blog is just so amazing. I don’t know where else I would have got all the information I had, but from this article. I count myself lucky for having come across this great work. I’m so impressed with this blog.Joomla developer hire

    ReplyDelete