According to MySQL doc, I must use union and temporary tables.
It seems I have to do something along the line of this:
There are cases where I use OR queries quite often. I am talking about
queries like this "where column_1 = 123 OR column_2 = 123". It seems
MySQL indices cannot properly optimize this.
Are there plugins or snippets out there that automagically hide the
complexity of using temporary tables for such queries?