Essentially what I want to do is this:
SELECT Id, Email FROM User WHERE Email in ('first.last1%','first.last2%')
I am using this in a trigger and would like to come up with a query to match users based on the email prefix. Ideally, I like to avoid using a loop since I'm trying to avoid governor limits.
Anyone have a solution to this?