I have an InnoDB table that has 100k records and I need to do a search on this table on one column for a “quick search” style search box. The where clauses is currently using ’ …WHERE name LIKE ‘%xyz%’ LIMIT 20’, but this is proving too slow.
Any suggestions?
Sam