MySQL, Query, Optimization, Web Performance, Database.
following will cause abandon index query, full-text scanning 1.1, use the where= or <> operator in the where clause Note: primary key support. Non-primary keys are not supported 1.2, avoid using or After testing, it is not the use of or must not use the index, in most cases is not used index, but