需求
字段varchar 多个可能查询,使用where in/where or/ find_in_set不同查询比较。
符合条件记录数为 3735 条。
FIND_IN_SET
+----+-------------+----------------+------------+------+---------------+---------+---------+-------+---------+----------+-----------------------------------------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+----------------+------------+------+---------------+---------+---------+-------+---------+----------+-----------------------------------------------------------+
| 1 | SIMPLE