Re: Searching on AlphaNumeric Content Only
| From: | Ashley Sheridan | Date: | Fri, 04 Sep 2009 15:02:07 +0000 |
| Subject: | Re: Searching on AlphaNumeric Content Only | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-297681@lists.php.net to get a copy of this message | ||
On Fri, 2009-09-04 at 17:00 +0200, Lupus Michaelis wrote:
> Ashley Sheridan a écrit :
> > What's wrong with using the wildcards that are built into most SQL
> > variants?
>
> Performance issues. Like is an operator to avoid when possible.
>
> --
> Mickaël Wolff aka Lupus Michaelis
> http://lupusmic.org
>
You'll have far greater performance issues if you retrieve all those
records and attempt to do the same thing inside of PHP...
Thanks,
Ash
http://www.ashleysheridan.co.uk