Not phonetic, but I meant like cat*, basically wildcard matches
Not phonetic, but I meant like cat*, basically wildcard matches
I thought it does that without you having to type the asterisk...
% is the wildcard.Originally Posted by cl_out
Not phonetic, but I meant like cat*, basically wildcard matches
And then there is Death
If you are talking about the actual SQL query, that is correct.% is the wildcard.Not phonetic, but I meant like cat*, basically wildcard matches
I'm talking about mysql's built-in fulltext index
You'd need to use LIKE and RLIKE, no?
Yeah, I'm pretty sure % doesn't work with binary operators.
Edit: Since clout is a lazy bum
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
Last edited by Endless; 07-07-2005 at 10:33 PM.
And then there is Death
My GOD! What have I done? I just wanted to be able to search every inch of every post like I would using normal SQL with out a retarded search index ;_;
clout is right, the rest of you suck. When using vBulletin, you can search using * as a wildcard. In other words, if you search for bullet, you'll get all occurances of the exact word of bullet. If you search for *bullet*, you can end up with posts including such words as vBulletin. So yeah, when searching in the forums using the forums, use * as a wildcard.
ed, if you ever have a word you want to add to the three-letter-limit-thingy, just come and post in this thread and an admin can probably add it in.
EDIT: You can also use AND or OR when searching for multiple words.
Bow before the mighty Javoo!
BoB..
I'm talking about mysql's built-in fulltext index
And then there is Death
You still all suck and so does clout in that case. Since this discussion has been based on searches on posttext, you don't need to do partial searches in the database itself if you can do them right here in the forums.
Bow before the mighty Javoo!
The idea behing the built-in text index is that it allows natural search, i.e., if I searched for "caike", it would also return posts containing "cake". Besides, I wouldn't be surprised if the built-in full index took less space than vB's search index.
And then there is Death
A spellchecking search? o_o
Bow before the mighty Javoo!
Hey, quit molesting my thread and get back on topic! This thread is about sorting, not search indexes.
Wait until vB3.5.0 and then we'll talk about any changes to code. It should be within the next six months. But for now, the answer to the original question is 'no'.
Bow before the mighty Javoo!
Posting Permissions
