On 11 December 2003 11:52, Constantin Brinzoi wrote: > 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? SELECT * FROM x_table WHERE name LIKE "%part_of_name%" Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: m.ford@xxxxxxxxxxxxxx Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
