Using LIKE and IN operators - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Using LIKE and IN operators

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-11 : 09:25:21

Madhuri writes "Hi !
I am working on a project where there are searches based on keywords .
We need to search in the description , title , keywords fields of the table . I would love to use the select statement like

select * from JOB where title in ( like '%accounts%' , like '%manager%')
and description in ( like '%accounts%' , like '%manager%')
and keywords in ( like '%accounts%' , like '%manager%')

But this dosn't work . So we are using like

select * from JOB where (title like '%accounts%') and (title like '%manager%') and (description like '%accounts%') and (description like '%manager%') and ( keywords like '%accounts%') and (keywords like '%manager%')

Select statement is becomming bigger as keywords increase and the search fields increase.

Please help me in this. Suggest an easy method for this

Thanks"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources