I have below values in my database.

1. been Lorem Ipsum and scrambled ever
2. scrambledtexttextofandtooktooktypetexthastheunknownspecimenstandardsincetypesett

Here is my query:

SELECT
  nBusinessAdID,
  MATCH (`sHeadline`) AGAINST ("text" IN BOOLEAN MODE) AS score 
FROM wiki_businessads
WHERE MATCH (`sHeadline`) AGAINST ("text" IN BOOLEAN MODE)
  AND bDeleted ="0" AND nAdStatus ="1"
ORDER BY score DESC, bPrimeListing DESC, dDateCreated DESC

It's not fetching first result, why? It should fetch first result because its contain text word in it. I have disabled the stopword filtering.

This one is also not working

SELECT
  nBusinessAdID,
  MATCH (`sHeadline`) AGAINST ('"text"' IN BOOLEAN MODE) AS score 
FROM wiki_businessads
WHERE MATCH (`sHeadline`) AGAINST ('"text"' IN BOOLEAN MODE)
  AND bDeleted ="0" AND nAdStatus ="1"
ORDER BY score DESC, bPrimeListing DESC, dDateCreated DESC

Thanks
Avinash