tickone's recent timeline updates tickone's recent timeline updates |
tickoneV2EX member #581239, joined on 2022-05-11 13:22:30 +08:00 |
tickone's recent replies
May 27, 2022 Replied to a topic by brader › 程序员 › 如何低成本解决模糊搜索问题 |
可以试试这样查，扫描 name 索引，不是全表扫描，稍微好一点
select * from table where id in (
select id from table where name like '%哈哈%'
)
select * from table where id in (
select id from table where name like '%哈哈%'
)
Select Language