On Wednesday 31 October 2001 02:32 am, you wrote:
> So, I'd recommend giving that a try.  From my understanding (limited) of
> MySQL, use = in the case of $id=2, and LIKE in the case of firstName
> LIKE "justin".

Um...you *can* do that, but I don't think you want to.  Using LIKE means that 
MySQL has to do a lot more searching on all your database records.  Instead 
of searching for an exact match, where it can look at things like string 
length, first characters and other simple criteria, it now has to evaluate 
the entire contents of the field in case there's a possible match somewhere 
in the string.  Much, much slower.

So, yes it works, but you pay a performance price for it. 


PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to