mardi 3 février 2015

Can you use the field value as a pattern for LIKE in an SQLITE query

If I have mytable with: id = 1, name = 'J' and id = 2, name = 'K', how can I use name as my pattern in a search?



SELECT * FROM mytable WHERE 'Jack and Jill' LIKE name+%

Aucun commentaire:

Enregistrer un commentaire