SQL like operator, can I obtain results based on multiple words?

Question

I'm using SQL Like operator in asp for my project, and I want to obtain all the results that have the words that I inserted in the search field.

So, if I search "fish restaurant", I'd like to obtain all the restaurants that have both "fish" and "restaurant" in the fields I'm searching.

So far, my code is as follow:

sql = "SELECT dbo.tbl_activity where (name like '%"&MySearchCriteria&"%' OR  description like '%"&MySearchCriteria&"%' OR  metadescription like '%"&MySearchCriteria&"%' OR  products like '%"&MySearchCriteria&"%' OR brand like '%"&MySearchCriteria&"%') "&QueryAdd&" Order By Nome"

is it a way to achieve what I'm trying to do?

Yair Maron · Accepted Answer · 2021-06-07 09:23:49Z

2

Your approach is fine.

However you can make the query a bit more pleasant to read like this:

SELECT  *
FROM    tbl_activity
WHERE   CONCAT_WS(' ', name, description, ...) LIKE '%fish%'
AND     CONCAT_WS(' ', name, description, ...) LIKE '%restaurant%'
AND     ...

...and so on for each word in your search field

answered Jun 7, 2021 at 9:23

Yair Maron

1,98012 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL like operator, can I obtain results based on multiple words?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related