iPhone SQLite questions - SELECT WHERE

I got an application using SQLite to save data. and 2 Field of Data, 1. Title, 2. Category.

For example, I saved 3 rows of Data

Title Category

• Johnny's birthday BIRTHDAY

• Meet Johnny OTHER

• Mom's birthday BIRTHDAY

I've already get all of these data and display on tableV开发者_如何学运维iew, Now when user wants to display data that belongs to "BIRTHDAY" category, (which is "Johnny's birthday , Mom's birthday")

How to make this function? I know using SELECT WHERE.... but still can't figure out :(

I know how to write the SQL query to display only single data.

but I have multiple data's, so I'm searching for help to display multiple data..

PS. I'm using UIPickerView to let users choose Categories.

SELECT * FROM `table` WHERE category = "BIRTHDAY";

Select title, category from YOURTABLE where category= "BIRTHDAY"