Full-text and pharse search - 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)

Full-text and pharse search

Author

Topic

imughal
Posting Yak Master

192 Posts

Posted - 2006-04-07 : 12:27:24

Hi,

I am working Full-text Search. I have image filed to store different files. I have done the search.

My query:

SELECT * from doc
where CONTAINS(file_info, 'computer')

The result is OK. But now i want to pass more parameter like computer books then query not executed.

so pls tell me how to do pharse search.

Thanks

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-04-08 : 13:25:06

imughal,

Have you tried using an OR?

SELECT * FROM doc
where CONTAINS(file_info, 'computer')
OR CONTAINS(file_info, 'mainframe')

imughal
Posting Yak Master

192 Posts

Posted - 2006-09-20 : 02:37:43

yeah i have tried it works when use query like mainframe but when i used two word like main frame whenever space occurs its not work.
so pls tell me how to accomplish with space. like this

SELECT * FROM doc
where CONTAINS(file_info, 'computer')
OR CONTAINS(file_info, 'main frame') [it not works]

regards,
irfan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources