![]() ![]() ![]() In private chat with your buddy finds given word SELECT DISTINCT datetime(m.timestamp, 'unixepoch', 'localtime'), m.author, m.body_xml FROM JOIN conversations c ON c.id = m.convo_idįinds private chat with your buddy SELECT DISTINCT datetime(m.timestamp, 'unixepoch', 'localtime'), m.author, m.body_xml FROMĬ.identity LIKE '%%' -case insensitive Following queries on main.db works for me:įinds group chats SELECT DISTINCT datetime(m.timestamp, 'unixepoch', 'localtime'), c.id, m.author, m.body_xml FROM
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |