Simple MySQL vBulletin search from my main site

[Eikinskjaldi]

Performing the search this way is server intensive, it actually has to look at the entire contents of text fields to do the match.

Assuming you have swapped to fulltext searching in admincp, vbulletin comes with fulltext indices which will greatly improve the efficiency of the search

select whatever from post where match(title, pagetext) against ('word')