How to do use FMDB search ?(Case sensitive)

53 views

Skip to first unread message

unread,

Oct 10, 2016, 12:29:35 PM10/10/16

to FMDB

Here is my table data:

id user content

1 ohh The

2 abc the

3 klm he

4 ohh the

5 ohh a

Here is my code:

NSString *sql = @"select * from t_table where content like '%%%t%%;

FMResultSet *result = [dataBase executeQuery:sql];

Here is my result:

id user content

1 ohh The

2 abc the

4 ohh the

problem:

I just want to t , no T . Who told me what to do?

unread,

Oct 10, 2016, 1:51:35 PM10/10/16

to fm...@googlegroups.com

On Oct 8, 2016, at 3:12 AM, agon...@gmail.com wrote:

problem:
I just want to t , no T . Who told me what to do?

This is a SQLite thing, this should get you started: