I’m explaining the scenario. I’m coding a WHERE statement with OR in it. I’d like to get field that indicates me which OR is matched, without using different SQL query. So for example if I’m matching the title get a field with the value to true or get back a field with title as the value.

Here the query I’m testing:

SELECT * FROM books WHERE title LIKE :s || description LIKE :s || author LIKE :s ....