lake view phase twin house with installment

====== select * from Mls where EnItem like '%lake view phase twin house with installment%' group by CompanyCode ORDER BY UpdateStamp DESC =============

====== select *, MATCH (EnItem) AGAINST ('lake view phase twin house with installment' IN BOOLEAN MODE) AS Relevance from Mls where MATCH (EnItem) AGAINST ('lake view phase twin house with installment' IN BOOLEAN MODE) ORDER BY Relevance DESC,UpdateStamp DESC LIMIT 0,20 =============