chalet 3rd floor 105 for sale amwaj

====== select * from Mls where EnItem like '%chalet 3rd floor 105 for sale amwaj%' group by CompanyCode ORDER BY UpdateStamp DESC =============

====== select *, MATCH (EnItem) AGAINST ('chalet 3rd floor 105 for amwaj' IN BOOLEAN MODE) AS Relevance from Mls where ID>0 and PropertyFor like '%Sale%' and MATCH (EnItem) AGAINST ('chalet 3rd floor 105 for amwaj' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 0,20 =============