Problem: MySQL statement using the% (percent semicolon) after like is not the more efficient the slower it runs!
Total Time: 0.0489 sec 0.0691 0.0485 0.0467
SELECT ' Goods_name ', ' goods_img ', ' sku_id ', ' import ' from ' goods ' WHERE ' goods_name ' like '%iphone%ipod% ' and ' stime ' < 1413877244 and ' etime ' > 1413877244 ORDER by ' flag ' DESC
Total Time: 0.0460 sec 0.0430 0.0493 0.0783 0.0496
SELECT ' Goods_name ', ' goods_img ', ' sku_id ', ' import ' from ' goods ' WHERE ' goods_name ' like '%iphone% ' and ' goods_name ' like '%ipod% ' and ' stime ' < 1413877367 and ' etime ' > 1413877367 ORDER by ' flag ' DESC
total time: 0.0458 seconds 0.0441 seconds 0.0449 seconds
SELECT ' Goods_name ', ' goods_img ', ' sku_id ', ' import ' from ' goods ' WHERE ' goods_name ' like '%%%%%%%%%%%%%%%%%%%%%%%iphone %ipod%%%%%%%%%%%%%%%%%%%%%%% ' and ' stime ' < 1413877997 and ' etime ' > 1413877997 ORDER by ' flag ' DESC
Practice has shown that the number of percent semicolons does not affect the speed of SQL operations. These methods are almost identical in efficiency.
These are the results of my test. Individuals can choose the writing according to their actual needs! advice is best to choose another one!
Problem with% (percent semicolon) after using like in MySQL statement