Yeh...

Have sort of like a Multiple search string...

Satan

If you want to count the words, and don't want to search all posts, here's a start for ya:
SELECT word.title, searchindex.postid FROM word INNER JOIN searchindex ON word.wordid = searchindex.wordid WHERE word.title like '%something%'

This one will return all the post id's where the search term is found.

Not a bad hack, not something I would personally use myself, but a good hack nonetheless.

Good job!

- SaintDog

SELECT DISTINCT t.title FROM thread t, post p,searchindex s, word w WHERE s.wordid=w.wordid AND w.title='YOURNAME' AND p.postid=s.postid AND t.threadid=p.threadid

alle the titles of the threads with the word YOURNAME in it. Simply count them ...

(2.2.6)

Zajako, i dig your hacks but i diss your avatar ::P
i would install this hack as its a great idea, however i dont want to drain my badnwith or lag my forums up :P I definately think this is collio though, If there was a magically way to preserve bandwith i definately would

This is cool, and I installed it, however I get a DB error if someone has a ' in their name.

is there anyway to point out where the name said and named screamed occured? like which forum and such