match a concatinated string

[jacquesy]

I need to perform a search query on my database whereby I first need to concatinate two columns that will form the sting to be searched. I can do this using that like but I need to use match instead, any ideas?

What I amtrying to do:

select * from news where match (concat (news_title,' ',news_title)) AGAINST ('a_value') GROUP BY dbNewsId;

Its the "..(concat (news..........." part thats the problem.

Does anybody know know the correct syntax to perform such a query or is there a beter way to do this?

Thanks! 😃

[barand]

Perhaps by using FULLTEXT facility.

[jabi]

Did you remember to create a full text index on the two columns that you need to match?

Reference can be found at http://www.mysql.com/doc/en/Fulltext_Search.html

No concat is required as shown in the example:
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');