hey guys i have a fairly large database of about 600 000 rows. i would like a query that does this select title from vids where title like "%query%" limit 10 but obliviously this query puts a lot of strain on my server, so it wouldn't do me any good to run this query i tried using fulltext search function but the returned values aren't quite what i wanted. is it possible to use like "%%" on an index, or is there a better way to get this done with little to no stress to the server any help would be greatly appreciated thanks