为什么SQL LIKE无法在Microsoft Access中工作? [英] Why doesn't SQL LIKE work in Microsoft Access?

问题描述

我想做一个搜索语句并查询类似的东西

I want to my make a search-statement and query things like this

select * from table where col like '%vkvk%' 

但是经过反复试验，我得出的结论是访问不适用于LIKE或 通配符运算符.有人有其他解决方案吗，因为我实际上并不喜欢访问，所以我真的不知道.

But with trial and error I've come to the conclusion that access doesn't work with LIKE or wildcard operators. Does anybody have some other solutions because I ain't so in to access actually, so I really don't know.

推荐答案

尝试:

select * from table where col like '*vkvk*'

对通配符使用星号.

这篇关于为什么SQL LIKE无法在Microsoft Access中工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！