Re: SELECT LIKE with "%" and without "%"
| From: | Eleonora De Marinis | Date: | Mon, 04 May 2009 07:01:36 +0000 |
| Subject: | Re: SELECT LIKE with "%" and without "%" | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46168@lists.php.net to get a copy of this message | ||
$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 ///////////////////////////+ _