php 正则表达式与 mysql IN 查询的排序问题 php 正则表达式 $regexp_utf = "/^[\x{4e00}-\x{9fa5}A-Za-z0-9_]+$/u"; //UTF-8汉字字母数字下划线正则表达式 $str = "2015_01_17学习php"; $str2 = "2015/01/17 学习php"; if (preg_match($regexp_utf,$str)) { print("只包含UTF-8汉字字母数字下划线"); } else { print("除UTF-8汉字字母数字下划线外还包含有其他字符"); } if (preg_match($regexp_utf,$str2)) { print("只包含UTF-8汉字字母数字下划线"); } else { print("除UTF-8汉字字母数字下划线外还包含有其他字符"); } mysql IN 查询的排序问题 select * from test where id in(3,1,5) order by find_in_set(id,'3,1,5'); select * from test where id in(3,1,5) order by substring_index('3,1,2',id,1); select * from table where id IN (3,6,9,1,2,5,8,7) order by field(id,3,6,9,1,2,5,8,7);