HELLO.
I want to run a query on a MySQL FULLTEXT index like this:

$sql = "EXPLAIN SELECT * 
FROM BOOKS 
WHERE MATCH (title, subtitle, author, edition, publisher, notes)
AGAINST (\ 'alighieri \')"; 

How can I do it with "DATABASE SOURCE QUERY BUILDER"?

Thanks.

Hello Gianmario,

Can you please explain what exactly are you trying to achieve?

Hello Teodor
On my page I have a search form with only one field and a button to start my search for any text that may be contained in these database fields (title, subtitle, author, edition, publisher, notes ...) FullText indexed.
For example, how can I build this query with "DATABASE SOURCE QUERY BUILDER"?

SELECT * FROM `books` 
WHERE 
MATCH (title, 
     author, 
     subtitle, 
     publishing 
     edition, 
     notes, 
     class, 
    division, 
    section, 
    subsection) 
AGAINST ('William')

Thanks.

In the Filter tab add the first field that you want to look into, then add the rest and use OR, when adding them, like:

Thanks for your reply.
The query that I see in the image works perfectly.
But not this.

SELECT * 
FROM BOOKS 
WHERE 
title LIKE "%william% "
OR subtitle LIKE "%william%"
OR author LIKE "%william%"
AND id_library = 1 
LIMIT 0, 30 

Only this query (with brackets) fetch data correctly.

SELECT * 
FROM BOOKS 
WHERE 
(
      title LIKE "%william%"
     OR subtitle LIKE "%william%"
     OR author LIKE "%william%"
) 
AND id_library = 1 
LIMIT 0, 30 

Please, how can I set it with Data Source Query Builder?
Thanks.

Hi,
in the Query Builder use
for condition "contains" instead of =
and for the Default value use %
This should work for you.