Is it possible to do the following:
If I have a column called 'fruit' in a table called 'mytable' which contains cells such as:
apple orange orange
...can I query this so that
SELECT * FROM mytable WHERE fruit='apple' && 'apple'
would return nothing, since there are no cells with the word 'apple' twice,
SELECT * FROM mytable WHERE fruit='orange' && 'orange'
would return the third cell, because 'orange' DOES appear twice?
If this question doesn't make sense to you, you're probably not best-suited to respond :-)