http://qs321.pair.com?node_id=724158


in reply to Building a notification system based on MySQL

It sounds like when you've got multiple values, you might want to use an in statement, I.E.
If SlotA = Value and SlotB = Value and SlotC in (value1, value2) then +notify GroupA
I'm curious if you have another table that you're getting the Group to notify from - it seems likely to me that there's a way to determine the person to notify in a single sql query (without requiring building a query up dynamically in perl), but without knowing more about the specifics of the tables in question, it's impossible to say.