Re: Replace like
| From: | Andrey Hristov | Date: | Fri, 07 Dec 2001 05:16:08 +0000 |
| Subject: | Re: Replace like | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14856@lists.php.net to get a copy of this message | ||
you can use REGEXP instead of like.
Regards,
Andrey Hristov
----- Original Message -----
From: <sharmad@goatelecom.com>
To: <php-db@lists.php.net>
Sent: Friday, December 07, 2001 5:40 AM
Subject: [PHP-DB] Replace like
> Can anyone tell me how would i replace the following query with a "="
>
> SELECT * from table_name WHERE name LIKE "%name%";
>
> I want to have the same functionality like "LIKE" but having no LIKE word in
> it.
> Basically i want it for a search engine and i heard that using LIKE decreases
> the speed like nothing as compared to "="
>
> -TIA
> Sharmad
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>