Better u try with this: select * from Front_Desk where Hobbies='Hockey'
hopefully it will work fine On Dec 17, 9:27 am, Priyanka <[email protected]> wrote: > CUSTOMER > > CustID FName LName Hobbies > 1 Fred Smith Fishing, Rollerball, Hockey > 2 Sally Jones Sailing > 3 Brian Wilson Gliding, Sailing, Singing, Hockey > > now from this table i wanted to findout the customer whose hobby is > 'Hockey' without changing the table becoz my orginal table is too > complicated to change the schema.. > plz suggest the query...
