LIKIE INSTR

SELECT  url FROM test_url WHERE   FROM_UNIXTIME(create_time,'%Y%m%d %H') < '20171218 00'  AND  no_open_times+no_ad_times+ok_times<=11

AND INSTR(url,"b2b168.com") AND NOT INSTR(url,"9")  ORDER BY id  DESC ;

编程效率

执行效率