> From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]] > Subject: [PHP-DB] wildcard in mysql search with php > > 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?
Sure... you do it like this... search column_name from table_name where column_name like '%admin%' -- __ _ Tyler Nally / /__ ____ _(_)___ ____ ____ _________ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\____/_/ /_(_)____/_/ \__, / http://www.legion.org /____/ /____/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]