Re: Selecting specified values from different coulmns

[shreehari srinivasan]

Thanks a lot for trying to help me, I tried this, but I need the name of game under their respective coulmn itself. But by using this union clause, I'm getting output like this

mysql> select game1 from sports where game1 like'%ball'
-> union
-> select game2 from sports where game2 like'%ball';
+------------+
| game1 |
+------------+
| basketball |
| football |
+------------+

I need basket ball to be under game1 while football to be under game2
Please let me know if you know a way to do so... :)