MySQL’s FULLTEXT Stopwords - Learning PHP, MySQL, & JavaScript
by Robin NixonThis appendix contains the more than 500
stopwords referred to in the section “Using a FULLTEXT
Index” in Chapter 7, Practical PHP. Stopwords are words that are
considered so common as to not be worth searching for, or storing, in a
FULLTEXT index. Theoretically, ignoring
these words makes little difference to the results of most FULLTEXT searches, but makes MySQL databases
considerably smaller and more efficient. The words are shown here in
lowercase but apply to uppercase and mixed-case versions, too:
This excerpt is from Learning PHP, MySQL, and JavaScript . Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites.
- A
a’s, able, about, above, according, accordingly, across, actually, after, afterwards, again, against, ain’t, all, allow, allows, almost, alone, along, already, also, although, always, am, among, amongst, an, and, another, any, anybody, anyhow, anyone, anything, anyway, anyways, anywhere, apart, appear, appreciate, appropriate, are, aren’t, around, as, aside, ask, asking, associated, at, available, away, awfully
- B
be, became, because, become, becomes, becoming, been, before, beforehand, behind, being, believe, below, beside, besides, best, better, between, beyond, both, brief, but, by
- C
c’mon, c’s, came, can, can’t, cannot, cant, cause, causes, certain, certainly, changes, clearly, co, com, come, comes, concerning, consequently, consider, considering, contain, containing, contains, corresponding, could, couldn’t, course, currently
- D
definitely, described, despite, did, didn’t, different, do, does, doesn’t, doing, don’t, done, down, downwards, during
- E
each, edu, eg, eight, either, else, elsewhere, enough, entirely, especially, et, etc, even, ever, every, everybody, everyone, everything, everywhere, ex, exactly, example, except
- F
far, few, fifth, first, five, followed, following, follows, for, former, formerly, forth, four, from, further, furthermore
- G
get, gets, getting, given, gives, go, goes, going, gone, got, gotten, greetings
- H
had, hadn’t, happens, hardly, has, hasn’t, have, haven’t, having, he, he’s, hello, help, hence, her, here, here’s, hereafter, hereby, herein, hereupon, hers, herself, hi, him, himself, his, hither, hopefully, how, howbeit, however
- I
i’d, i’ll, i’m, i’ve, ie, if, ignored, immediate, in, inasmuch, inc, indeed, indicate, indicated, indicates, inner, insofar, instead, into, inward, is, isn’t, it, it’d, it’ll, it’s, its, itself
- J
just
- K
keep, keeps, kept, know, knows, known
- L
last, lately, later, latter, latterly, least, less, lest, let, let’s, like, liked, likely, little, look, looking, looks, ltd
- M
mainly, many, may, maybe, me, mean, meanwhile, merely, might, more, moreover, most, mostly, much, must, my, myself
- N
name, namely, nd, near, nearly, necessary, need, needs, neither, never, nevertheless, new, next, nine, no, nobody, non, none, noone, nor, normally, not, nothing, novel, now, nowhere
- O
obviously, of, off, often, oh, ok, okay, old, on, once, one, ones, only, onto, or, other, others, otherwise, ought, our, ours, ourselves, out, outside, over, overall, own
- P
particular, particularly, per, perhaps, placed, please, plus, possible, presumably, probably, provides
- Q
que, quite, qv
- R
rather, rd, re, really, reasonably, regarding, regardless, regards, relatively, respectively, right
- S
said, same, saw, say, saying, says, second, secondly, see, seeing, seem, seemed, seeming, seems, seen, self, selves, sensible, sent, serious, seriously, seven, several, shall, she, should, shouldn’t, since, six, so, some, somebody, somehow, someone, something, sometime, sometimes, somewhat, somewhere, soon, sorry, specified, specify, specifying, still, sub, such, sup, sure
- T
t’s, take, taken, tell, tends, th, than, thank, thanks, thanx, that, that’s, thats, the, their, theirs, them, themselves, then, thence, there, there’s, thereafter, thereby, therefore, therein, theres, thereupon, these, they, they’d, they’ll, they’re, they’ve, think, third, this, thorough, thoroughly, those, though, three, through, throughout, thru, thus, to, together, too, took, toward, towards, tried, tries, truly, try, trying, twice, two
- U
un, under, unfortunately, unless, unlikely, until, unto, up, upon, us, use, used, useful, uses, using, usually
- V
value, various, very, via, viz, vs
- W
want, wants, was, wasn’t, way, we, we’d, we’ll, we’re, we’ve, welcome, well, went, were, weren’t, what, what’s, whatever, when, whence, whenever, where, where’s, whereafter, whereas, whereby, wherein, whereupon, wherever, whether, which, while, whither, who, who’s, whoever, whole, whom, whose, why, will, willing, wish, with, within, without, won’t, wonder, would, would, wouldn’t
- Y
yes, yet, you, you’d, you’ll, you’re, you’ve, your, yours, yourself, yourselves
- Z
If you enjoyed this excerpt, buy a copy of Learning PHP, MySQL, & JavaScript.
