I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try.
Thank you guys. Rikin On Fri, Apr 13, 2012 at 10:28 AM, Jim Giner <jim.gi...@albanyhandball.com>wrote: > > "Rikin Parekh" <riki...@gmail.com> wrote in message > news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... > This is the sample data provided to me. I need to query this data only. And > column name can be without spaces. I need to know the query that will give > me the result irrespective of the syntax errors in question table. Can > someone please guide or help? > > Thanks, > Rikin > it looks like it will do what you want. I don't know why you are asking > instead of trying it out. :) > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >