Re: SQL question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am sorry without equal "=" sign

SELECT * FROM x_table WHERE name Like "%part_of_name%"

there are actually three ways to do this:
"%part_of_name%"      part_of_name appears anywhere
"%part_of_name"        part_of_name appears at the end
"art_of_name%"           part_of_name appears at the begining
 
M.Mamedov


----- Original Message ----- 
From: "Muhammed Mamedov" <muhammed@xxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Thursday, December 11, 2003 2:00 PM
Subject: Re:  SQL question


> It should be as follows:
> SELECT * FROM x_table WHERE name Like = "%part_of_name%"
> 
> Hope this helps,
> M.Mamedov
> 
> ----- Original Message ----- 
> From: "Constantin Brinzoi" <aurel@xxxxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> Sent: Thursday, December 11, 2003 1:51 PM
> Subject:  SQL question
> 
> 
> > I know it is  possible to search a database like this:
> > 
> > SELECT * FROM x_table WHERE name="%part_of_name%"
> > 
> > but I don't know for sure the correct command.
> > 
> > Could you tell me the right syntax?
> > 
> > TIA
> > Aurel.
> > 
> > -- 
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> > 
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux