Question

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

例如,我节省了3个数据流。

标题

星期五
Meet Johnny 其他
星期四

I ve already get all of these data and display on tableView, 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 :(

我知道如何写卡,只显示单一数据。

但是,我有多种数据,因此,我为显示多种数据而寻找帮助。

PS。 I m 利用UIPickerView让用户选择类别。

Answer 1

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

Answer 2

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

友情链接