I am newbie to sybase iq. I came to know that in sybase iq i can create a word index on column and with a delimeter also.
Following is my table structure having a wd index on hobbies column.
create table users (
id int not null,
name varchar(50) not null,
hobbies varchar(5000) null);
create wd INDEX users_wd
Now i have to write a query to find the users whose hobbies is playing chess or reading books and also i want to the group by count on the hobbies. Then how to write a query with group by having contains function.