How can I do the equivalent of:
!FIND_IN_SET('needle', haystack)
!FIND_IN_SET('needle', haystack)
Equals to 0 doesn't work, you have to use null.
SELECT id FROM table WHERE FIND_IN_SET(needle,haystack) IS NULL
.andWhere('(NOT FIND_IN_SET(:userID, notification.deletedBy) OR notification.deletedBy IS NULL)',{userID:userId})