MySQL FIND_IN_SET function

The MySQL FIND_IN_SET function is a cheeky little number. Essentially what it will do is return the position of a value within a set of comma separated values. The basic syntax is: FIND_IN_SET(str,strlist) Where str is the value you want to find and strlist is the set of comma separated values. So, for example FIND_IN_SET(‘3′,’7,2,8,11,3,5,6’) would return 5 because 3 is the […]