Re: how to do query on partial field contents ???
| From: | Frank Flynn | Date: | Tue, 24 Feb 2004 18:21:01 +0000 |
| Subject: | Re: how to do query on partial field contents ??? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33103@lists.php.net to get a copy of this message | ||
And if you'd like to make wild carding optional keep your code the way it
is:
$query .= " AND
model LIKE
'".$_GET['search']."'";
And put a comment on the web page "Use the % for wild cards".
The thing about:
$query .= " AND model LIKE
'%".$_GET['search']."%'";
Is it will return many results if $_GET['search'] is very small like one
letter.
Good Luck,
Frank
On 2/24/04 8:20 AM, "php-db-digest-help@lists.php.net"
<php-db-digest-help@lists.php.net> wrote:
> From: "Nitin Mehta" <nitinmehta@kappa.net.in>
> Date: Tue, 24 Feb 2004 13:18:24 +0530
> To: <php-db@lists.php.net>, "-{ Rene Brehmer }-"
> <metalbunny@metalbunny.net>
> Subject: Re: [PHP-DB] how to do query on partial field contents ???
>
> for partial match
>
> like 'value' doesn't work, use
> like '%value%'
>
> Hop that helps
> Nitin
>
> ----- Original Message -----
> From: "-{ Rene Brehmer }-" <metalbunny@metalbunny.net>
> To: <php-db@lists.php.net>
> Sent: Tuesday, February 24, 2004 11:57 AM
> Subject: [PHP-DB] how to do query on partial field contents ???
>
--
Frank Flynn
Poet, Artist & Mystic