Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Doing a SQLite MATCH using only negated terms
- SELECT * FROM fruit WHERE fruit MATCH '-apple'
- SELECT * FROM fruit WHERE fruit MATCH 'pear -apple'
- select * from fruit where fruit NOT match 'apple'
- select * from fruit except select * from fruit where fruit match 'apple';
Advertisement
Add Comment
Please, Sign In to add comment
