Re: Re: Search "all" in mysql
| From: | Henrik Hansen | Date: | Sun, 30 Sep 2001 10:06:41 +0000 |
| Subject: | Re: Re: Search "all" in mysql | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-69351@lists.php.net to get a copy of this message | ||
charette@sneezy.org (Mark Charette) wrote:
> Actually, if you want to return all, just drop the "where" clause
> completely.
but thet you have to check the input:
normally you would have:
select blah from table where field like '%something%'
if nothing if selected you just insert a % on something's place
select blah from table where field like '%%%'
and no check on input is needed (AKAIK).
--
Henrik Hansen