Re: %Like%
| From: | Michael Dearman | Date: | Wed, 12 Jul 2000 07:19:01 +0000 |
| Subject: | Re: %Like% | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1060@lists.php.net to get a copy of this message | ||
Chris Hughes wrote:
>
> Hi all,
> does anyone know the O(n) for the like command on mySQL? I've use it a
> lot in the current application I'm working on and there doesn't seem to be
> any slow down. Any longer term effects of it?
>
Hi Chris,
Don't know about the O(n). In Paul Dubois' book,
he recommends not using the double %what% unless that's
actually what you need. It's got something to do with
better optimization if you can use the what% form.
pg 186, 'MySQL'.
Mike D.