sql - Is there a way to search a FTS5 table for having EITHER element of the query string without using OR in Sqlite?

Question

I know that I can use SELECT * FROM myTable WHERE name MATCH 'andrew OR bill' to find all entries with either Andrew or Bill in them.

But is there a way I can just use the string 'andrew bill' as a query and get the same result? That is SELECT * FROM myTable WHERE name MATCH *SOME METHOD* 'andrew bill' will return the same as the query above? I need this for my website where users can search for entries in a html input field and requiring all key word to be present is a little too restrictive.

I was thinking about replacing all spaces with " OR " but I am hoping for a more elegant, less error prone solution...

question from:https://stackoverflow.com/questions/65541035/is-there-a-way-to-search-a-fts5-table-for-having-either-element-of-the-query-str

Answer 1

Waitting for answers