Re: how to match all words

2007-03-27 Thread fenlon
Pat, I am by no means great with sql, but i think i may be able to help you. You just need to load up your query with or statements. As i understand your question, you will be searching name for several keywords (x1,x2,...) and address for several keywrods (y1,y2...) SELECT * FROM clients WHER

"proximity" query help.

2007-03-27 Thread fenlon
Here is my problem. I have a table called dictionary The dictionary has the following columns `wordID` int(10) unsigned NOT NULL auto_increment, `position` int(10) unsigned NOT NULL , `WORD` varchar(120) NOT NULL default '' What this actually holds is a index of words and their locations of a b