RE: [PHP-DB] Wildcards
| From: | Gurhan Ozen | Date: | Mon, 06 May 2002 20:41:47 +0000 |
| Subject: | RE: [PHP-DB] Wildcards | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18993@lists.php.net to get a copy of this message | ||
That query doesn't make sense... All you are looking for is to get a
resultset containing ONLY the rows where name is John. So, just write:
SELECT ID, NAME, ADDRESS FROM users WHERE NAME='John';
By the way, in SQL, the wildcard character for regular expressions is the
'%' not '*' .
Gurhan
-----Original Message-----
From: Morten Nielsen [mailto:mosgaard2000@hotmail.com]
Sent: Monday, May 06, 2002 4:46 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Wildcards
Hi,
I am trying to make a SELECT command like this:
$qid =db_query("
SELECT ID, NAME, ADDRESS
FROM users
WHERE ID=* AND NAME='John'
");
Is it somehow possible to have a wildcard, so it returns all records, where
the name is john and the ID is not important?
Regards,
Morten
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php