Yeah, it can definitely be confusing. Interestingly, in your example, it's the location of the verb "show" that makes the difference. The non-tech user's "show me fast cars AND show me red cars" could be two separate queries appended together, which is logically similar to a single query of "show me red cars or fast cars." But that doesn't make it any easier to design a UI or to get users to do their google search properly. :)
--Max Sat May 5 10:57:38 2007
Yeah, it is almost a verb and implied parentheses grouping there.
There's an asymmetry here, with "computer or" mapping to "human and", as my example, "computer and" kind of also mapping to "human and" ("show me cars that are fast *and* red!"), but the "human or" doesn't map to anything in a usual query.... a human reading of "show me red cars or fast cars" might be pick one of the two set of cars to show me, I don't care which.
--Kirk Sat May 5 12:49:00 2007
I read an interesting paper recently about an alternative notation for boolean logic that makes it really clear what's going on. It's pretty cool!
--ApM Sun May 6 15:33:35 2007
I test drove the Fit and wasn't impressed (especially after driving the Toyota Yaris & Corolla). The big problem was the jackrabbit starting acceleration followed by glacial hill & highway acceleration.
--ericball Mon May 7 22:51:19 2007
Hi. Nice site! Cool guestbook.
--eblnxq Wed May 23 06:12:02 2007
What a joy to find such clear thkining. Thanks for posting!
--Jayde Mon Jun 20 03:38:37 2011
Thanks, Robson. The only way I know to use wildcards at the biegnning of your query string is by using regular expressions and (although I'm not 100% sure,) I don't think you can combine regular expressions with the fulltext search expressions. What you could do is add a regular expression mode option to the script such that a person can elect to do a search providing only the end of the word, and it would run the search using the separate select statement with a regular expression but, sadly, the fulltext options simply don't include a stemming selector. Maybe someday
--Malaz Fri Apr 12 03:44:40 2013