RE: [PHP-DB] SQL question
| From: | Ford, Mike [LSS] | Date: | Thu, 11 Dec 2003 11:58:16 +0000 |
| Subject: | RE: [PHP-DB] SQL question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31990@lists.php.net to get a copy of this message | ||
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@leedsmet.ac.uk
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211