Searching Databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Dr. PHP
Forum Newbie
Posts: 11
Joined: Sun Nov 24, 2002 8:46 am

Searching Databases

Post 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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply