I have looked up and lower sqlite.org and should not figure that one out. I am accustomed to MySQL and so i think maybe I'm looking over something.

Begin to see the following code:

sqlite> select id,event_number,must_say from events where id=28;
28|'28'|'AFK'
sqlite> select id,event_number,must_say from events where must_say='AFK';
sqlite> select id,event_number,must_say from events where must_say like 'AFK';
sqlite> select id,event_number,must_say from events where must_say like 'A%';
sqlite> select id,event_number,must_say from events where must_say=='AFK';
sqlite>

Obviously, I truly was expecting the next to become came back for The suggestions above queries, not only the first:

28|'28'|'AFK'

I am getting this behavior on all TEXT fields. It appears I can not search whatsoever.

This is actually the schema of my occasions table, using the irrelevant fields overlooked:

CREATE TABLE events (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    EVENT_NUMBER INTEGER,
    MUST_SAY TEXT
);

Any ideas? Among the finest to have the ability to search by arbitrary text fields within the table.

Edit: I am using SQLite3.

You may even have whitespace inside your posts.

You can observe spaces with

select '|' || must_say || '|' from events

You can observe unprintables with

select hex(must_say) from events