Opposite of MySQL FIND_IN_SET Opposite of MySQL FIND_IN_SET database database

Opposite of MySQL FIND_IN_SET


FIND_IN_SET returns the index of the match if it is found, and returns 0 if it is not found. Since 0 is FALSE you can just use NOT FIND_IN_SET('needle', 'haystack')


SELECT id FROM table where !FIND_IN_SET(needle,haystack).......

Its working for me...