MySQL, Query, Optimization, Web Performance, Database.
0.06s 2, in convert multiple or. When the field is an index, both can use the index, or the efficiency is better than in 3, name like ‘abc%’ rewritten as name>=’abc’ and name<’abd’; Note: Million-level data test, name is not indexed faster than the latter query; after adding an index to the field,