Adobe Experience Manager Sites & More

sureshy2015 · 10/15/15

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

Peter_Puzanovs · 10/15/15

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

Peter_Puzanovs · 10/15/15

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

Lokesh_Shivalingaiah · 10/15/15

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

kautuk_sahni · 10/19/15

Hi

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

I hope this would help you.

Thanks and Regards

Kautuk Sahni

dan_klco · 2/22/18

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

Kamaraj_AEM · 3/2/25

Here is the updated Link:

SQL 2 Query for full text search.