lundi 4 janvier 2016

Which sqlite operator is used for pattern match?

I can use LIKE to find occurance of pattern in a table if table has rows (red, redd, dred, green)

WHERE column LIKE '%red%' 

will return (red, redd, dred).
Is there operator for opposit matching?

WHERE column OPERATOR 'green, blue, yellow'

should return (green)

Aucun commentaire:

Enregistrer un commentaire