如何一次在数据库中搜索5列 [英] How to search in 5 Columns at a time in database

问题描述

select A.*,B.equipment_group,C.type 
from equipment as A 
inner join equipment_group as B on B.id=A.egroup 
inner join equipment_type as C on C.tid=A.etype 
where C.type like '%$dropvalue%' 
or A.ename like '%$dropvalue%' 
or B.equipment_group like '%$dropvalue%'

这是我要在数据库中搜索的查询，我正在从文本框中获取dropvalue.这意味着无论您在文本框中输入的内容是什么，它都会根据该值在数据库中进行搜索..

它正在工作，但是如果有更多记录，那么寻找任何时间都可以帮忙.

this is my query to search in database i am taking dropvalue from a textbox. that mean what ever you enter in text box it will search in database by that value..

It is working But if more records are there it is taking time to search can any one help.

推荐答案

dropvalue％' 或 A.ename like ' ％

dropvalue%' or A.ename like '%

dropvalue％' 或 B.equipment_group 喜欢 ' ％

dropvalue%' or B.equipment_group like '%

dropvalue％'

dropvalue%'

这是我要在数据库中搜索的查询，我正在从文本框中获取dropvalue.这意味着无论您在文本框中输入的内容是什么，它都会根据该值在数据库中进行搜索..

它正在工作，但是如果有更多记录，这将需要一段时间才能进行搜索.

this is my query to search in database i am taking dropvalue from a textbox. that mean what ever you enter in text box it will search in database by that value..

It is working But if more records are there it is taking time to search can any one help.

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