GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Babaganoosh · 07-07-2011, 06:01 PM

You're definitely going to want to do a fulltext query instead of a LIKE. Like queries are painfully slow for things like this.

Check this page for info on fulltext searching.
http://dev.mysql.com/doc/refman/5.1/...xt-search.html

07-07-2011, 06:01 PM
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	You're definitely going to want to do a fulltext query instead of a LIKE. Like queries are painfully slow for things like this. Check this page for info on fulltext searching. http://dev.mysql.com/doc/refman/5.1/...xt-search.html