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: [EMAIL PROTECTED]
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

Reply via email to