mercredi 12 août 2015

Using the SQLite LIKE clause

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 GLOBclause be used instead of LIKE, or perhaps some other wildcard patterns?

Many thanks in advance!

Aucun commentaire:

Enregistrer un commentaire