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
