Not Getting result as expected

[Manoj Amin]

Hi
I am not getting expected result as expected. When I search for "pink Panther" and I am getting result for pink and panther both. What I like to have is to have result with exact match "pink Panther" word first and then all matches with word "pink" and "panther". How do I do it ?.

Below is my current SQL.

SELECT *, MATCH(productid,description,details,Keyword) AGAINST ('pink,panther' IN BOOLEAN MODE) as rank
FROM tblProduct
WHERE (MATCH(productid,description,details,Keyword) AGAINST ('pink,panther' IN BOOLEAN MODE)) Order by Rank desc