I two simple tables: words and sindex. Used for indexing words in website's pages.
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,
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. ).