Like google-search or any other search-box, search "all columns as single text" is a simple and universal tool, but I not seet how to do it using
No problem if it is an extension: I need an extension that offers a full-text-search with a kind of
contains(*,text) (the same
SELECT *) instead to concatenate each column-value.
There are times when a formal structured query language is overkill, and the easiest way to find the right content is to perform a search, like you would with a search engine such as Google or Yahoo (...) JCR-SQL2:
SELECT * FROM [nt:base] WHERE CONTAINS([nt:base],'full-text-query')