SELECT * FROM table WHERE id IN(5,3,7,1) ORDER BY FIELD(id,5,3,7,1)
记录按照5,3,7,1的顺序返回
如果没有ORDER BY FIELD将按 1,3,5,6的顺序返回
2014-5-14 9:27 Wednesday
2012-4-1 11:43 Sunday
执行，就会报 The definition of table 'table1' prevents operation UPDATE on table 'table2'
update table2 set item = replace(item,'A27-','A28-') where id in( select id from table1 where item like ...
