在查询中喜欢运算符 [英] Like operator in query

问题描述

我正在搜索数据...并且我有多个字段.用于expl

i m searching data...and i have multiple fields.for expl

SqlCommand cmd = new SqlCommand("select emp_code,emp_name,Br_name,dept_name,designation_name,emp_gender,emp_mobile,emp_email,emp_doj from employee_info where emp_code like %'" + txt_search.Text + "'% or emp_name like %'" + txt_search.Text + "'% or Br_name like % '" + txt_search.Text + "'% or dept_name like %'" + txt_search.Text + "'% or designation_name like %'" + txt_search.Text + "'% or emp_gender='" + txt_search.Text + "' or emp_mobile like %'" + txt_search.Text + "'% or emp_email like %'" + txt_search.Text + "'% or emp_doj like %'" + txt_search.Text + "' % ", con);

我们如何在查询中写％?plz reply

how can we write the % in query?plz reply

推荐答案

我曾在其中一个查询中使用过像运算符
希望对您有帮助

I have used like operator in one of me queries
hope this helps

sqlstr = "SELECT IPAIPNO_REG,IPAIPNO, T3.BEDTRNPATNAME,' ',' ',BEDTRNPATAGE, "
       sqlstr = sqlstr & " BEDTRNOCCUSEX, ' ',BEDTRNWRDCODE,BEDTRNRMCODE, IPAPOLCOMPCODE,IPADUMMY1,IPAADMDATE,IPAADMTIME  FROM"
       sqlstr = sqlstr & " TBL_IPA_TN_IPADMS T1,TBL_IPA_TN_BEDTRN T3 WHERE t1.IPAIPNO_REG = T3.BEDTRNIPNO_REG"
       sqlstr = sqlstr & " AND BEDTRNSTATUS = 'O' AND  BEDTRNOCCBYPAT='Y' AND IPAIPNO IN "
       sqlstr = sqlstr & " (SELECT MAX(IPAIPNO) FROM TBL_IPA_TN_IPADMS GROUP BY IPAIPNO_REG) "

       If objPatientDetailsEnquiryBussinessObjects.MRNo <> 0 Then
           sqlstr = sqlstr & " AND IPAIPNO_REG LIKE '" & objPatientDetailsEnquiryBussinessObjects.MRNo & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.ipno <> 0 Then
           sqlstr = sqlstr & " AND IPAIPNO LIKE '" & objPatientDetailsEnquiryBussinessObjects.ipno & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.patName <> Nothing Then
           sqlstr = sqlstr & " AND BEDTRNPATNAME LIKE '%" & objPatientDetailsEnquiryBussinessObjects.patName & "%'"
       End If
       If objPatientDetailsEnquiryBussinessObjects.BillPatType <> Nothing Then
           sqlstr = sqlstr & " AND IPAPAYTYPE LIKE '" & objPatientDetailsEnquiryBussinessObjects.BillPatType & "%'"
       End If

将％保留在单个引号.

Keep % inside the single quotes.

...'%" + txt_search.Text + "%'...

用一次替换您的查询

replace your query with this once

select emp_code,emp_name,Br_name,dept_name,designation_name,emp_gender,emp_mobile,emp_email,emp_doj
from employee_info
where emp_code
like '%" + txt_search.Text + "%' or emp_name
like '%" + txt_search.Text + "%' or Br_name
like  '%" + txt_search.Text + "%' or dept_name
like '%" + txt_search.Text + "%' or designation_name
like '%" + txt_search.Text + "%' or emp_gender='" + txt_search.Text + "' or emp_mobile
like '%" + txt_search.Text + "%' or emp_email
like '%" + txt_search.Text + "%' or emp_doj
like '%" + txt_search.Text + "%'

这篇关于在查询中喜欢运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！