Re: Searching on AlphaNumeric Content Only
| From: | Lupus Michaelis | 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