Re: SELECT LIKE with "%" and without "%"
| From: | Ahmet Caner | Date: | Wed, 24 Feb 2010 10:31:41 +0000 |
| Subject: | Re: SELECT LIKE with "%" and without "%" | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46908@lists.php.net to get a copy of this message | ||
"Eleonora De Marinis" <eleonora.demarinis@garr.it>, haber iletisinde sunlari
yazdi:49FE92D0.2060406@garr.it...
> $sql = "SELECT * FROM table WHERE ID ='$_GET[id]' AND title LIKE
> '%$_GET[word]%'";
>
>
>
> -------- Original Message --------
> Subject: [PHP-DB] SELECT LIKE with "%'" and without "%'"
> From: Emiliano Boragina <emiliano.boragina@gmail.com>
> To: php-db@lists.php.net
> Date: 05/03/2009 01:43 AM
>> Hello.
>>
>> I am using this:
>> $sql = "SELECT * FROM table WHERE ID LIKE '%$_GET[id]%' AND title LIKE
>> '%$_GET[word]%'";
>>
>> But I want exactlu ID, not one part of many possibles Ids in the DB.
>> How can I do that?
>>
>> Thanks
>>
>> +
>> _
>> // Emiliano Boragina _
>> // Diseño & Comunicación //////////////////
>> +
>> _
>> // emiliano.boragina@gmail.com /
>> // 15 40 58 60 02 ///////////////////////////
>> +
>> _
>>
>
>
>