Eyes on Final Fantasy Forums > Reference > General Archive > Feedback Forum Archive > Search results sorting

[-N-]

I thought it does that without you having to type the asterisk...

[Endless]

Originally Posted by cl_out

Not phonetic, but I meant like cat*, basically wildcard matches

% is the wildcard.

[Samuraid]

Originally Posted by Endless

Originally Posted by cl_out

Not phonetic, but I meant like cat*, basically wildcard matches

% is the wildcard.

If you are talking about the actual SQL query, that is correct.

[crono_logical]

I'm talking about mysql's built-in fulltext index

[Yamaneko]

You'd need to use LIKE and RLIKE, no?

[Endless]

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

[edczxcvbnm]

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 ;_;

[Loony BoB]

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.