Re: Re: Search "all" in mysql
| From: | Mark Charette | Date: | Sat, 29 Sep 2001 22:57:07 +0000 |
| Subject: | Re: Re: Search "all" in mysql | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69326@lists.php.net to get a copy of this message | ||
Actually, if you want to return all, just drop the "where" clause
completely.
----- Original Message -----
From: "Henrik Hansen" <hh@mailserver.dk>
> d@mindbash.com (Daniel alsén) wrote:
>
> > Hi,
> >
> > i am writing a simple searchengine for a couple of mysql tables.
> >
> > i have no problem handling searches when there is something entered in
the
> > searchfield - or selected in a dropdown menu. But, when nothing is
selected
> > i want to display all content of the table. Is there a value in mysql
that
> > equals to all? Like * would do in some systems.
>
> % is the one
>