Hello everybody,
I two simple tables: words and sindex. Used for indexing words in website's pages.
Code:
CREATE TABLE words ( 
id int(9) unsigned not null auto_increment,
word varchar(32) not null,
primary key (id)
);

CREATE TABLE sindex (
id int(9) unsigned not null,
page varchar(250) not null,
key (id)
);
Now, what am trying to do is a boolean search on the pages that contain ... say both 'hello' and 'world'. How would that be done? Can it be done in one query or should I process the results externaly ( via php, perl .. etc. ).

Thanks in advance.