Does TiKV Support Fuzzy Queries

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TIKV是否有模糊查询

| username: TiDBer_59ZckvWa

【TiDB Usage Environment】Poc
【TiDB Version】6.3
【Encountered Issue】Does TIKV support fuzzy queries
【Reproduction Path】What operations were performed to encounter the issue
【Issue Phenomenon and Impact】

【Attachment】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: xfworld | Original post link

Could you describe it more clearly?

3
| username: OnTheRoad | Original post link

SQL is compatible with the MySQL 5.7 protocol. For more details, you can refer to the compatibility section in the documentation.

4
| username: 近墨者zyl | Original post link

When supporting fuzzy queries, such as like, it is important to note that % cannot be at the front as it will prevent the use of indexes.

5
| username: 近墨者zyl | Original post link

Which specific fuzzy query are you referring to? Please list them out as well.