SV: [PHP-DB] wildcard in mysql search with php
| From: | Trond Erling Hundal | Date: | Thu, 18 Oct 2001 12:58:22 +0000 |
| Subject: | SV: [PHP-DB] wildcard in mysql search with php | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13477@lists.php.net to get a copy of this message | ||
The % can be empty space or 'n' characthers. The LIKE command in mysql also
make the query very dynamic.
- trond
> -----Opprinnelig melding-----
> Fra: Dave Watkinson [mailto:d.watkinson@mightymatch.com]
> Sendt: 18. oktober 2001 14:50
> Til: php-db@lists.php.net
> Emne: 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
>
>
> --
> 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
>
>