MYSQL Query to export data order by given values in comma separated string:
June 7th, 2009
MYSQL Query to export data order by given values in comma separated string. If you want to get the record in an specific order you can do it like this:
SELECT * FROM {TABLE_NAME} WHERE {FIELD_NAME} IN ( 23, 234, 543, 23 ) ORDER BY FIELD({FIELD_NAME}, 23, 234, 543, 23 )
Example: SELECT * FROM `product_master` WHERE paSKU IN (’1a6′,’1a1′,’1a8′,’1a3′,’1a4′) ORDER BY FIELD (paSKU,’1a6′,’1a1′,’1a8′,’1a3′,’1a4′)
Bookmark To:
