Re: Wildcards
| From: | Morten Nielsen | Date: | Mon, 06 May 2002 21:02:19 +0000 |
| Subject: | Re: Wildcards | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18995@lists.php.net to get a copy of this message | ||
It is because it is a search function where a user can enter an ID, NAME and
ADDRESS to search after. If one of the fields are empty it should use the
wildcard.
"Morten Nielsen" <mosgaard2000@hotmail.com> wrote in message
news:20020506203726.23803.qmail@pb1.pair.com...
> Hi,
> I am trying to make a SELECT command like this:
>
> $qid =db_query("
> SELECT ID, NAME, ADDRESS
> FROM users
> WHERE ID=* AND NAME='John'
> ");
>
> Is it somehow possible to have a wildcard, so it returns all records,
where
> the name is john and the ID is not important?
>
> Regards,
> Morten
>
>