search string

[acctman]

i'm trying to search terms that may or may not have a space... ex term: iPod Black 30.  the results would be everything except, "ipod black used 30" and "used". so basically its finding all complete matching terms individual matching terms and skipping over any entry that may match but has a non-match word in it and of course the entry where nothing matches.

 

table:

prod

-- ipod black 30

-- ipod 30

-- ipod black used 30

 

types

-- ipod

-- 30

-- black

-- used

[fenway]

Huh? Search how?