MySQL, Query, Optimization, Web Performance, Database.
like ‘%.com’ solve: 1. If you must use the % preamble and the data length is not large, such as a URL, you can flip the data into the database and check it. LIKE REVERSE’%.com’; 2, using the coverage index 1.6, when using the index field as a condition, if it is a composite index, you should use