Match against query in SQL

SELECT MATCH(Firstname,Lastname)
AGAINST('+hy'IN BOOLEAN MO开发者_JAVA技巧DE)Firstname,Lastname 
FROM tbldemo 

This is my query, but the table is returning the entire table instead of returning the data contains 'hy'. How can it be possible?

You need a where clause...

How about this:

SELECT Firstname,Lastname 
FROM tbldemo 
WHERE MATCH(Firstname,Lastname) AGAINST('+hy' IN BOOLEAN MODE)