SELECT LIKE with "%" and without "%"

Prev: mysql_close()
Next: Need a tool for mysql file

From: "Ahmet Caner" on 24 Feb 2010 05:31

---

"Eleonora De Marinis" <eleonora.demarinis(a)garr.it>, haber iletisinde sunlari
yazdi:49FE92D0.2060406(a)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(a)gmail.com>
> To: php-db(a)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(a)gmail.com /
>> // 15 40 58 60 02 ///////////////////////////
>> +
>> _
>>
>
>
>

 | 
Pages: 1
Prev: mysql_close()
Next: Need a tool for mysql file