RIP Philo

Not-very-Frequently Asked Questions



The boolean full-text search capability supports the following operators:

+ A leading plus sign indicates that this word must be present in each row that is returned.

- A leading minus sign indicates that this word must not be present in any of the rows that are returned.

By default (when neither + nor - is specified) the word is optional, but the rows that contain it are rated higher.

> < These two operators are used to change a word's contribution to the relevance value that is assigned to a row. The > operator increases the contribution and the < operator decreases it.

( ) Parentheses group words into subexpressions. Parenthesized groups can be nested.

~ A leading tilde acts as a negation operator, causing the word's contribution to the row's relevance to be negative. This is useful for marking “noise” words. A row containing such a word is rated lower than others, but is not excluded altogether, as it would be with the - operator.

* The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it should be appended to the word to be affected. Words match if they begin with the word preceding the * operator.

" A phrase that is enclosed within double quote (‘"’) characters matches only rows that contain the phrase literally, as it was typed. The full-text engine splits the phrase into words, performs a search in the FULLTEXT index for the words. The engine then performed a substring search for the phrase in the records that were found, so the match must include non-word characters in the phrase.

If the phrase contains no words that are in the index, the result is empty. For example, if all words are either stopwords or shorter than the minimum length of indexed words, the result is empty.
Wayne (AHA)
August 31st, 2006 8:54am


1 - The U.S. of A. is not all that she is made out to be
2 - Capitalism when done right is the right thing
3 - Socialism when done right is the right thing
4 - Genetic predisposition exists
5 - Genetic predisposition should not exist
6 - Racism is universal
7 - There are no universal truths
8 - I want love
9 - Ooh! Shiny
10 - Freedom is costly

11 - 10 is an oxymoron
12 - Hehe! He said moron!
13 - Exceptions are not rules
14 - Exceptions prove the rule
15 - Exceptions do not return value
16 - Violence is valid
17 - Violence invalidates
18 - Moron!
19 - Fucking Moron!
20. [grinning, ducking, running]

21. And you can't use Google to find that out because...?
22. That's what I get for trying to get some conversation
    going. Some 19 doing a 23.
23. Thanks for stating the obvious. Moron.
24. This thread has gone south (or, west)
25. Reducing the fundamental arguments to catalogued &
    readily repeatable will either free us from our past,
    or doom us all to a life of reciting obscure numbers
    for eternity.
26. Salad cream
27. Fruit Show
100011011. If we re-worked the idea into a binary system,
    we could recite a single number and it would encompass
    all of the arguments we wanted to make. (In Hex then...
28. I made it to the sidebar!
29. (this insult reserved for future insults)
30. Deadpan. Gales of laughter ensued.

31. I've always thought Joel was full of sound advice, and
    followed his stuff for years, but this recent article
    just goes to show he's really lost the plot.
32. I have a PhD.
33. Poo
34. I wish muppet would stop dragging X here
  (used with supplementary number, e.g. 34c!)
  a: psychopaths
  b: damsels in distress
  c: stupid news links
  d: people who post muppet posts who just keep the stupid
  thing going
35. muppet is a troll.
36. I feel so left out.
37. Don't feed the trolls.
38. When do you people ever get any work done/don't you
    have anything better to do than to post here?
39. Drat, X beat me to it. (used with name parameter,
    e.g. 39/Dennis)
40. Prove it.

41. Disprove it.
42. The Babel Fish argument (logically disproving God's
43. I already said that.
44. That 43 was prime.
45. Anybody want some gmail invites?
46. It's disingenuous to refer to the most primitive,
    arcade exercises when trying to disprove the value
    of an ideology, but that's what you get when you
    chat with people who don't know what they're fucking
    talking about.
47. What are you, retarded?
48. Sympathy reply.
49. I regularly engage in sex with two women simultaneously.
50. Been there, done that.

51. The problem with the world today is stupidity. I'm
    not saying there should be a capital punishment for
    stupidity, but why don't we just take the safety
    labels off of everything and let the problem solve
52. It doesn't do anything in Opera...
53. I have nothing to add, but I can't overcome my
    animal urge to vocalize regardless.
54. Fuck off and die.
55. HOLY MOTHER OF GOD (fill in name), could you _be_
    any dumber?  seriously?  I mean, it feels like the
    human race must have achieved some kind of local
    maxima with you...  you exist as an evolutionary leg
    all by yourself.  kids of REALLY REALLY DUMB backwoods
    white trash rednecks must grow up wanting to be JUST


1) Spam

2) Impersonation - Posting with a fake name is ok, but
postings with someone else's name will get deleted if
the "real" person requests it or if the fake posting
isn't funny or obvious enough.

3) Personal Information - Posting someone else's
personal information will usually get deleted. 

4) Spew - Too many repeated postings on the same topic
with no discussion or analysis will probably get deleted.
Sometimes Dan comes up with a funny bit of profanity,
but 5 or 6 "Take it up the ass, (fill in whatever group
he's complaining about today)!" posts in a row will
usually be deleted.

5) Meta - Some meta will get deleted, some won't.  If
it's interesting, it'll probably stay.  But if it's just
a complaint about a particular post being deleted,
there's a good chance the complaint will be deleted, too.

From a recent thread:

>>> "Basically the system is: if you're not a moderator
deal with the occasional deletion of perfectly normally
posts."  - anonymous whiner

Yeah, honestly, what's so wrong with that?  If it's
half-way interesting (or less) it doesn't get deleted. 
You're still arguing for the posts that are so banal
that nobody would miss them.  Why do you care about
those posts?  - Wayne (AHA)

6) Anything else some random moderator feels like
deleting that no other moderator undeletes.

NOTE - Three strikes and you're temporarily out, your
IP gets blocked for a couple days.


Daddy's House:

Namesake Stock:



The correct way to open a banana is from the end with
the tab - the end that attaches to the bunch.  Monkeys
and other morons who open bananas from the bottom are
doing it wrong.

When Stoned Wheat Thins (or similar crackers) are
eaten with peanut butter, the peanut butter should
be put on the "top," that is the side with the salt
on it, which is slightly convex.  The people who put
peanut butter on the flat, no-salt side are doing it
Permalink Send private email Ward 
March 8th, 2007 7:30pm
there are people who put it on the flat, no salt side?  incredible.
Permalink worldsSmallestViolin 
March 8th, 2007 7:43pm
So far, it's been a gender difference: only women have said that they put it on the wrong side.
Permalink Send private email Ward 
March 8th, 2007 7:53pm
ah, that explains it.
Permalink worldsSmallestViolin 
March 8th, 2007 8:05pm
You missed the one about the toilet paper going over the top.  The people who put the roll on with the loose end hanging from the back are obviously closet pedophiles.
Permalink Send private email xampl 
March 8th, 2007 8:37pm
I'll add that, although I don't think that's as cut and dried.  _I_ certainly think the loose end should come off the top and hang on the side away from the wall, but I know people who are otherwise perfectly fine who do it with the loose end close to the wall.
Permalink Send private email Ward 
March 8th, 2007 11:38pm

This topic is archived. No further replies will be accepted.

Other topics: March, 2007 Other topics: March, 2007 Recent topics Recent topics