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. --kurt -- 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]
