i am using Navicat For SQLite .i have a simple question

how to add this in the query.

i want to show

if flags=1 then "Received" and if flags=2 then "sent"

flag is integer


my query is

select address,datetime(date, 'unixepoch', 'localtime'),text,flags
from shadow
WHERE shadow.address="123"
order by datetime(date, 'unixepoch', 'localtime')

This is off the cuff but I believe MySQL would use a IF() function or CASE WHEN ... THEN ... END. Look at MySQL's functions for details on what it can understands & expect.