: 18 October 2001 14:58
To: [EMAIL PROTECTED]
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*
Sure use:
SELECT * FROM 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]>
wro
wildcard in mysql search with php
>
>
> select from where like
> '%searchword%'
>
>
> RTFM!!!
>
>
>
> -Original Message-
> From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
> Sent: 18 October 2001 14:58
> To: [EMAIL P
> 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
select from where like
'%searchword%'
RTFM!!!
-Original Message-
From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 14:58
To: [EMAIL PROTECTED]
Subject: [PHP-DB] wildcard in mysql search with php
Hello all,
Is there a way to use wi
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 Datab
