Sure use: SELECT * FROM <table> WHERE foo LIKE '%$bar%'
selects all records where 'bar' is found somewhere in the search string. See also: http://www.mysql.com/doc/S/t/String_comparison_functions.html HTH :-) Russ On Thu, 18 Oct 2001 15:57:56 +0200 "Thomas \"omega\" Henning" <[EMAIL PROTECTED]> wrote: > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------# -- 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]