Re: Searching on AlphaNumeric Content Only

From: Date: Fri, 04 Sep 2009 16:02:53 +0000
Subject: Re: Searching on AlphaNumeric Content Only
References: 1 2 3 4 5  Groups: php.general 
Request: Send a blank email to php-general+get-297683@lists.php.net to get a copy of this message
Ashley Sheridan a écrit :
You'll have far greater performance issues if you retrieve all those records and attempt to do the same thing inside of PHP...
It's why I speak about « avoiding » and not « bannishing ». Like can be usefull, I used to use it. But it is not the a good answer to all problems. The problem with like operator is it can't use the index (or in a very limited way). So I try to warn about it. So said, I never submit an all-retrieving method. I know it isn't the solution too. -- Mickaël Wolff aka Lupus Michaelis http://lupusmic.org

« previous php.general (#297683) next »