RE: [PHP-DB] wildcard in mysql search with php

select <columnlist> from <tablename> where <columnname> like '%searchword%' RTFM!!! -----Original Message----- From: Thomas "omega" Henning [mailto:tomi@mediasoft.ro] Sent: 18 October 2001 14:58 To: php-db@lists.php.net Subject: [PHP-DB] wildcard in mysql search with php Hello all, Is there a way to use wildcards in search in a mySQL db? e.g. I have a dbase of over 24000 records and i can only search exact matches is there a way to search something like this : *admin* in mySQL? Or i have to do it by hand in PHP? Thanks Sir Thomas "omega" Henning -- 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