MySQL Unions – getting 2 values from 1 column

Hey everyone! Here is how to retrieve multiple values from the same table. My project had to do with job positions, but I have made the example a little easier to follow:

Let’s say in the usermeta table, each person has a left pocket, and a right pocket. Still with me?

We want to find out if any user has an apple in either pocket. The apple(s) can be in a user’s left pocket, right pocket, or both!
Continue reading MySQL Unions – getting 2 values from 1 column