I than did an "Advance Search", where I had to choice the equal to or not equal stuff
( that never stops being an annoyingly abstract question to pose, I wish you would thing that )
Yep, for me as a geek it's a bit funny when searching for Spice & Wolf DVDs to have the
advanced search form nearly literally match 1:1 a SQL database query like
SELECT * FROM 'products' WHERE 'title' LIKE "%spice%" AND 'media' = "DVD" AND 'adult' != "yes"
but most end users probably want a bit more "friendly" form where the backend just takes care
of the conversion...
(sorry if I offended any DB specialist by wrong use of quoting... ;-P )
edit: ugh, database/advanced search also needs an overhaul to correctly support DVD/Blu-Ray combo sets...
For ex. "Spice and Wolf Season 2 DVD/Blu-ray Complete Set" can't be found with "media = DVD", since it's only flagged Blu-Ray...