如何从数据库中按记录搜索? [英] How to search by Records from database?

问题描述

在数据库中如何搜索特定的列，例如按名称搜索或通过电子邮件搜索
请帮助..

In the database how to search particular column like search by name or search by Email
please help..

推荐答案

您有WHERE 条款，可以与LIKE 或BETWEEN 等命令一起使用，过滤器.
例如

You have the WHERE clause that you can use with commands such as LIKE or BETWEEN that you can use to do a filter.
For e.g.

select * from myTable where email like ''ABC.COM''

此外，通配符 [

In addition, wild card characters[^] like % and ? provide additional filtering criteria for a query.

在喜欢 [ ^ ]运算符.

Issue a T-SQL query in an SQLCommand[^] with a LIKE[^] operator.

很容易使用下拉列表和文本框，在下拉列表中选择列名称，然后在文本框中输入要搜索的字符串.

It is easy to use drop down list and a textbox, in the drop down list select the column name and in the textbox you write the string to be searched.

这篇关于如何从数据库中按记录搜索?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！