Searching Databases
Moderator: General Moderators
Searching Databases
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.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
http://www.mysql.com/doc/en/SELECT.html
http://www.mysql.com/doc/en/Functions.html
Mac