Kindly review this simple SQLite fiddle.
If any word in the column ITEM
of table TWO
matches any word in the column NAME_2
of table ONE
, there should be a result(s).
Tried many permutes, yet not sure how to form the query for achieving this. Should the GLOB
clause be used instead of LIKE
, or perhaps some other wildcard patterns?
Many thanks in advance!
Aucun commentaire:
Enregistrer un commentaire