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"
精彩评论