Solved

SQL 2 Query for full text search.

Need SQL2 Query for full text search .Do not want to use query builder.Please help me for the same.

Best answer by Peter_Puzanovs

Hey Suresh,

Have you looked at awesome post by:

They provide an example:

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.title, 'client')

(try to replace s.title with s.*)

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, 'client')

Thanks,

Peter

Accepted solution

Community Advisor

Hey Suresh,

Have you looked at awesome post by:

They provide an example:

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.title, 'client')

(try to replace s.title with s.*)

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, 'client')

Thanks,

Peter

you can use 'CONTAINS' to do that full text search. refer [1] and it gives an idea about it

Community Manager

Hi

Please have a look at this article, this is good read.

I hope this would help you.

Thanks and Regards

Kautuk Sahni

FYI since labs.6dglobal.com is down, here is the same post on JCRSQL2 queries on my personal blog:

Here is the updated Link:

Sign up