You would have to hand code this. You would use the explode() function to break up the string into an array around the comma, then write a loop to go through that array and then use explode again to break up the strings on the colon.
Then you could loop on those values and build the appropriate WHERE clause to find the results.