I have the scenario where i want my user to search his contact list by name, which is easy to do if he enters one name i can just search first and last name fields for a match of the string like.
WHERE _type = ‘contact’ and ( d.first_name like $1 or d.last_name like $1 )
to make it even better i can convert user input and field to lowercase to ensure we match case insensitive.
But lets say is there a simple way to search for a string which might be 2 words across the first and last name filed ?
Like where first + last like ‘Tom Miller’