使用通配符 [英] Using WildCard Character

问题描述

在我的应用程序中，我有一个搜索条件字段，其中有一个文档名称字段.
我的数据库中有一个名为$#％#$的文档.现在，我只想输入％来搜索文档.
我该怎么做?
我尝试了不同的操作，但无法正常工作.如果我在文档名称"字段中输入％，它将为我提供所有文档.但是，我只需要该文档.
谢谢，
Umesh Tayade

Hi,
In my application i have a search criteria field in which one document name field is there.
I have a document in my database with name $#%#$. Now, I want to search for document by entering only %.
How i do that?
I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document.
Thanks,
Umesh Tayade

推荐答案

#％#

.现在，我只想输入％来搜索文档.
我该怎么做?
我尝试了不同的操作，但无法正常工作.如果我在文档名称"字段中输入％，它将为我提供所有文档.但是，我只需要该文档.
谢谢，
Umesh Tayade

. Now, I want to search for document by entering only %.
How i do that?
I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document.
Thanks,
Umesh Tayade

您可以从

You may gain some better understanding from this page. In order to use a character defined as a wildcard in SQL, you would have to escape that character for it to be used as a literal in the query. The article I linked to explains how to do this.

这篇关于使用通配符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！