ilXor.com comprehensive keyword search

Message Bookmarked

Bookmark Removed

Now we're on the nice new server with its nice new hard disk there's space for a nice keyword index not created by Nicole, so now we have full keyword searching. Some limitations (of the database software):

No support for enclosing multiple words in quotes
Searching is Any Word, not All Words
Words below 4 letters are completely ignored

― Graham (graham), Thursday, 5 September 2002 11:20 (twenty-three years ago)

Thanks for doing that, Graham: it should be really useful.

― Nicole (Nicole), Thursday, 5 September 2002 11:37 (twenty-three years ago)

Hooray!

― Andrew (enneff), Thursday, 5 September 2002 11:37 (twenty-three years ago)

Excellent. Thanks.

― DeRayMi, Thursday, 5 September 2002 11:53 (twenty-three years ago)

wow, it works really well - it even throws up results in hyperlinked images, which is damn useful. Graham = all-round wonderful chap.

― zebedee, Thursday, 5 September 2002 11:57 (twenty-three years ago)

Not Graham's fault but this sucks:

No support for enclosing multiple words in quotes

Searching is Any Word, not All Words

― N. (nickdastoor), Thursday, 5 September 2002 12:05 (twenty-three years ago)

It's still better than nothing, though.

― Nicole (Nicole), Thursday, 5 September 2002 12:10 (twenty-three years ago)

graham,

is this php stuff hand coded from scratch by your good self or is it based on something else? i'm just thinking you could maybe release the table schemas / search code bits so that someone else here could have a look over them and try and implement the missing bits.

andy
who doesn't know the first thing about php to be honest but who has dicked around with postnuke.

― koogs, Thursday, 5 September 2002 12:23 (twenty-three years ago)

Sorry, of course it is. But I'll probably have to end up flitting between google, freefind and the nu-search for things that are tricky to find. Just being a librarian for a minute.

― N. (nickdastoor), Thursday, 5 September 2002 12:28 (twenty-three years ago)

Wahey! Now we know that there are 74 messages on ILX featuring the name 'Adorno'. Oops, now its 75!

― alext (alext), Thursday, 5 September 2002 12:31 (twenty-three years ago)

MySQL Fulltext Search (The server runs v3.something so you can ignore the boolean bit).

I'll look into implementing one or both of those features myself.

― Graham (graham), Thursday, 5 September 2002 12:33 (twenty-three years ago)

Will you be doing one for ILM also, Graham? As far as I can tell, this one just does ILE.

― zebedee, Thursday, 5 September 2002 12:35 (twenty-three years ago)

If you click the Search link at the bottom of any ILM page, or click the '>ILM' link at the top of the ILE search page.

― Graham (graham), Thursday, 5 September 2002 12:55 (twenty-three years ago)

Ah! Excellent. Thanks.

― zebedee, Thursday, 5 September 2002 13:01 (twenty-three years ago)

looks like 'match all words' is easy enough -

select * from table where match (column) against ('word1') and match (column) against ('word2');

seems to work.

pity about the lack of boolean stuff though - does everything you need.

andy

― koogs, Thursday, 5 September 2002 13:02 (twenty-three years ago)

One problem with that:
(42.36 sec)

But yeah, I think there is a less than elegant work around that will work without adding so much overhead.

― Graham (graham), Thursday, 5 September 2002 13:22 (twenty-three years ago)

it was fast when i did it against the 5 rows in the database here?

andy
i'll get my coat...

― koogs, Thursday, 5 September 2002 13:30 (twenty-three years ago)

I've mad quotes work and made it an All Words search by using their method to very quickly select possible messages, and then narrowing it down manually.

BORING PARAGRAPH: This has odd effects on the less than 4 letters thing, because the message has to be first be returned using the old method, ie contain a four letter word. So "C or D: Ellen Feiss" with or without quotes works because of the Ellen part, but "C or D" alone would be completely ignored. Plus the matching messages count is still based on an Any Word search.

Anything else Dastoor?

― grepmonkey (graham), Thursday, 5 September 2002 23:19 (twenty-three years ago)

(nu ansas)

― Graham (graham), Friday, 6 September 2002 09:12 (twenty-three years ago)

Why do you all know so much about computers? I just don't get it.

― the pinefox, Friday, 6 September 2002 09:15 (twenty-three years ago)

Graham you are wicked good.

― N. (nickdastoor), Friday, 6 September 2002 09:17 (twenty-three years ago)

i have seen a couple of thing coming up on google for this domain. how long might it take until the spiders find their way into all of the old threads here?? i don't really know how the google works.

― ron (ron), Friday, 6 September 2002 22:51 (twenty-three years ago)

excellent work graham b-b-b-but there's no way to search for 'arvo part'!

― mark p (Mark P), Friday, 6 September 2002 22:58 (twenty-three years ago)

Dear The Pinefox: many of us work in computing (like me, not that this means I know much) or study it at uni, like Graham. Any interweb mentalist gathering will have a good (or bad, perhaps) proportion of computer experts, even one centred on the arts.

― Martin Skidmore (Martin Skidmore), Saturday, 7 September 2002 15:02 (twenty-three years ago)

And I kind of know about this stuff (if not the SQL side) from my job and MSc. AND OR NOT Boolean mmm.

― N. (nickdastoor), Saturday, 7 September 2002 15:04 (twenty-three years ago)

You must be logged in to post. Please either login here, or if you are not registered, you may register here.