MS Access：在列中搜索星号/星号 [英] MS Access: searching a column for a star/asterisk

问题描述

我正在寻找一种搜索包含 * 的字符串数据类型的列的方法-问题是星号或星号是保留符号。以下查询无法正常工作：

I'm looking for a way to search a column of string datatype which contains a * - the problem is that the star or asterisk is a reserved symbol. The following query doesn't work properly:

select * from users where instr(pattern,"*")

如何编写访问查询以在列中搜索星号？

How can you write an Access query to search a column for an asterisk?

推荐答案

您可以使用方括号在Access中搜索重新定义的字符：

You can search for reseverd charaters in Access by using square brackets:

select * from users where pattern like "*[*]*"

这篇关于MS Access：在列中搜索星号/星号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！