Re: Replace like

Better yet, check the the MySQL docs and confirm whether or not there is a difference in speed between "=" and "LIKE". If there is I'd bet it's because LIKE forces a sequential read of the index, if not the column. I don't see how using a regex would be any faster? Happy to be proved wrong. Miles Thompson At 07:16 AM 12/7/2001 +0200, Andrey Hristov wrote:

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 -- 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