为什么SQL LIKE无法在Microsoft Access中工作? [英] Why doesn't SQL LIKE work in Microsoft Access?
本文介绍了为什么SQL LIKE无法在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屋!
查看全文