MySQL Forums
Forum List  »  Quality Assurance

Display Databse by Topic inside Category
Posted by: Supernova Omega
Date: October 16, 2011 03:16AM

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.

Options: ReplyQuote

Written By
Display Databse by Topic inside Category
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.