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.giner@xxxxxxxxxxxxxxxxxx>wrote: > > "Rikin Parekh" <rikin08@xxxxxxxxx> wrote in message > news:FAD9D02D-2ADD-4A31-B118-81D56183ED4A@xxxxxxxxx... > 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 > >
