faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

33 of 61 people (54%) answered Yes
Recently 3 of 10 people (30%) answered Yes

Entry

mySQL/PHP search - Is there a faster alternative to the 'like' query?

Jul 7th, 2001 15:47
Jonathan Sharp, Mark Hermansen, Ben Udall,


No...make sure you only use % on a match when absolutly necessairy. 
Don't start using it out of habbit. 
Example:
SELECT * FROM table WHERE colum LIKE "Bob%"