I have a table named users in my sqlite database. The table has id, firstname and surname columns. I want to filter in firstname + " " + surname . I wrote this but not work.
SELECT * FROM users WHERE id like 'LINA TA%' or firstname + ' ' + surname like 'LINA TA %'
I have a record firstname:LINA, surname:TANCREDI . Please help me