Today I found a use for MySQL’s UNION operator for the first time, and it works great. I used it to check 3 different tables for a match against a certain value, with one query statement. And it’s really fast.