摘要： <?php $mysql_server_name='localhost'; $mysql_username='root'; $mysql_password=''; $mysql_database='hairleft'; $conn=mysql_connect($mysql_server_name, $mysql_username,$mysql_password, $mysql_database); $arr1 = array("aa","bbb","ccc",&qu 阅读全文

摘要： 从表counter中读取数据字段car，然后全部插入到表counterss！！insert into counterss(car) select car from counter 阅读全文

摘要： 快速模糊查新按照匹配自定义排序，对于提高速度很重要！SELECT * FROM counterssORDER BY CASE WHEN car LIKE '%zhao%qi%yong%'THEN 0 WHEN car LIKE '%zhao%yong%qi%'THEN 1 WHEN car LIKE '%yong%zhao%qi%'THEN 2 WHEN car LIKE '%qi%zhao%yong%'THEN 3 WHEN car LIKE '%yong%qi%%zhao'THEN 4 WHEN car LIK 阅读全文