Display Databse by Topic inside Category

[Supernova Omega]

I'm new to MySQL and I need help please, I have a simple database called "food", it contains a table called "plants", which in turn contains the following 3 rows:
Word, Definition, Category, the table contains a list of words:

Example 1
Word: Apple
Definition: round and green color and grows in trees
Category: Fruits

Example 1
Word: Carrots
Definition: long and orange they grow underground
Category: Vegetables

Imagine there is a list of 100 of these fruits and vegetables mixed in one table called "plants". I want to fetch from that table only vegetables inside the row called "category" without the fruits. How can I do that? Thanks!



Edited 1 time(s). Last edit at 10/16/2011 05:22AM by Supernova Omega.