冰封的雪域

SELECT     CONCAT(         'ALTER TABLE ',         table_name,         ' RENAME TO i_',         substring(table_name, 4),         ';'     ) FROM     information_schema. TABLES WHERE     table_name LIKE 'yy%'; SELECT a.*, concat( 'alter table ', a.TABLE_NAME, ' rename ge_', SUBSTR( a.TABLE_NAME FROM INSTR(a.TABLE_NAME, '_') + 1 ), ';' ) FROM information_schema.`TABLES` a WHERE a.TABLE_SCHEMA = 'shiye';

thinkphp 自定义排序 $map['id'] = '10466,10390'; $data = M('article')->where($map)->field('id,title')->order('field(id,'.$map['id'].')')->select(); mysql 查询 "SELECT `id`,`title` FROM `article` WHERE `id` IN ('10466','10390') ORDER BY field(id,10466,10390)