Fulltext Question

[james2010]

Is it possible to do a fulltext search on multiple tables, if so how can I do this? Thanks 🙂

I've tried this which obviously doesn't work

SELECT * FROM articles, books WHERE MATCH(articles.title, articles.body, books.title, books.body) AGAINST('words')

[Elena_Mitovska]

I use operator LIKE for seraching for a math in columns of all types, even fulltext Before Searching all fields are concatenated in 1 string,and search is provided against this string.
You can form select for searching as many words as you need.
Here is example how to search for math of 2 words.

SELECT * FROM articles, books WHERE (
CONCAT_WS('',articles.title, articles.body, books.title, books.body) LIKE '%word1%'
AND
CONCAT_WS('',articles.title, articles.body, books.title, books.body) LIKE '%word2%' )

[james2010]

Thanks for your reply😃 it works perfectly for what I want to do. I found out that fulltext is limited to only one table per search. Unfortunately from what I've heard using the like opperator is significantly slower than a fulltext search, but the contents I'm searching is too small for to for that to effect it, so it's not a problem.