try SELECT * FROM x_table WHERE name LIKE "%part_of_name%" -----Original Message----- From: Constantin Brinzoi [mailto:aurel@xxxxxxxxxx] Sent: 11 December 2003 11:52 To: php-db@xxxxxxxxxxxxx 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 Email has been scanned for viruses by www.emf-systems.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
