Page 1 of 1

Searching Databases

Posted: Mon Nov 25, 2002 7:50 am
by Dr. PHP
I just caught part of another post about using the WHERE clause. The WHERE clause looks just like the perfect method for searching my database that I need, does this sound correct? I can use the WHERE cause with SELECT to pick out articles by authors last names, dates, etc, right? Can anyone give me an example of the WHERE being used in a PHP mysql_query, or send me the link back to that article I can't seem to find. Thanks.

Posted: Mon Nov 25, 2002 8:04 am
by twigletmac
Yup, the WHERE clause is used to limit a search to specific criteria. For more information (with examples):
http://www.mysql.com/doc/en/SELECT.html
http://www.mysql.com/doc/en/Functions.html

Mac