SELECT * FROM energy_minute_2_all_2012_10 WHERE INSTR(coding,'010')>0
(782621 row(s) returned)
Execution Time : 00:00:00:031
Transfer Time : 00:00:03:713
Total Time : 00:00:03:744
SELECT * FROM energy_minute_2_all_2012_10 WHERE coding LIKE '%010%'
(782621 row(s) returned)
Execution Time : 00:00:00:359
Transfer Time : 00:00:03:713
Total Time : 00:00:04:072