Display Databse by Topic inside Category
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.
Subject
Views
Written By
Posted
Display Databse by Topic inside Category
2422
October 16, 2011 03:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.