Nilesh Patil's blog

    How to show records in same order where IDs are put into the IN() clause?     1) SELECT id FROM table1 WHERE ... ORDER BY display_order , name 2) SELECT name , description , ... WHERE id IN ([ id ' s from first ])   The issue is that the second query does not return the results in the same order  that the IDs are put into the IN() clause.    Solution :-  SELECT name , description , ... FROM ... WHERE id IN ([ ids , any order ]) ORDER BY FIELD ( id , [ ids in order ])

Blob data used MySQL charset which is in my.ini default-character-set=latin1 Suppose I have a table with a BLOB field. The charset of the table is UTF-8. I connect to the DB and "SET CHARACTER SET utf8". Then I save binary data into the field. Then I retrieve the data, and it's not what I saved (corrupt). Because while retrieving data blob data used mysql default charset set. Ref : http://stackoverflow.com/questions/14734812/is-a-blob-converted-using-the-current-default-charset-in-mysql