How can I do the equivalent of:
!FIND_IN_SET('needle', haystack)
See Question&Answers more detail:os!FIND_IN_SET('needle', haystack)
See Question&Answers more detail:osFIND_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')