Which SQL query is better, MATCH AGAINST or LIKE?
Update As of MySQL 5.6 and later, InnoDB tables supports Match… Against. The first is much better. On MyISAM tables it will use a full text index against those columns. The other will do a full table scan doing a concat on every row and then a comparison. LIKE is only efficient if you’re doing … Read more