advanced code snippet search

Posted By

Wardy on 11/10/08


Tagged

mysql search order


Versions (?)

Sort results by order in list

 / Published in: SQL
 

URL: http://lists.mysql.com/mysql/209784

Expand | Embed | Plain Text 
  1. SELECT id, start_date FROM iddt
  2. WHERE id IN ('109k7','s3x6','sxmns','wt57')
  3. ORDER BY FIELD(id,'109k7','s3x6','sxmns','wt57')

Report this snippet  

You need to login to post a comment.