Re: SELECT LIKE with "%" and without "%"

From: 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 /////////////////////////// >> + >> _ >> > > >

« previous php.db (#46908) next »