Re: SELECT LIKE with "%" and without "%"
| From: | mrfroasty | Date: | Sun, 03 May 2009 00:11:22 +0000 |
| Subject: | Re: SELECT LIKE with "%" and without "%" | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46165@lists.php.net to get a copy of this message | ||
Emiliano Boragina wrote:
> Hello.
>
> I am using this:
> $sql = "SELECT * FROM table WHERE ID LIKE '%$_GET[id]%' AND title LIKE
> '%$_GET[word]%'";
>
This doesnt work?
$sql = "SELECT * FROM table WHERE ID='some_id' AND title='some_title';
--
Extra details:
OSS:Gentoo Linux
profile:x86
Hardware:msi geforce 8600GT asus p5k-se
location:/home/muhsin
language(s):C/C++,VB,VHDL,bash,PHP,SQL,HTML,CSS
Typo:40WPM
url:http://mambo-tech.net
url:http://blog.mambo-tech.net