Search MySQL Query

Question

I have the below Code

SELECT * FROM table WHERE MATCH(message) AGAINST ('Hello*')

If the message string is like this

"HelloWhatsHappening"

It dosent Work return anything

But if i have

"Hello WhatsHappening"

It works fine

It will also work if the string is as such:

"Hello= WhatsHappening"

Any Ideas?

Answer 1

You need to specify your query with a wild card, and add the "IN BOOLEAN MODE" statement. Like this:

SELECT * FROM table WHERE MATCH(message) AGAINST ('Hello*'  IN BOOLEAN MODE)

You also might have troubles searching for hello, because it is one of the stop words in MySQL. So it doesn't index the word if it is just hello, but it will index it if it's the word "HelloWhatsHappening".