Search Help

[Wafflehut]

So I've tried extensivly to find this answer myself instead of being 'that guy' and i'm posting it here because i think its the best fit i guess, but how do you do a search for a player by first and last name.
Example: the tool bar thats at the top that says
User CP, Rules, My Posts, New POsts, etc....there is a SEARCH feature. when i search by players name, it does a serach for his first and than a serach for his last. How do i make it search for his entire name? That way i dont have to sort through 200 posts that have just his first name in it?

[RGM81]

This isn't really a hockey chat question, per se, so I'm going to move this thread.

If you put quotation marks around the search string it will find just those results where the full name is entered. i.e. "Carey Price"

[Wafflehut]

I know its not but i didn't know where to post it. I've done the search with the quotatons but yet it still divides the name.

"Brandon Nolan"
still comes up
Brandon, Nolan
? am i doing it wrong or something?

[htwheelz01]

Welcome to SCF!

[Wafflehut]

thank you very much. at first its very over whelming, but i have a feeling i'm catching the hang of it.

[Molina00]

I'm sorry I can't answer your question. Mainly because I have wondered the same thing myself. I never have had much luck with the search feature here. I have tried the quotation marks and it never worked for me.

[Wafflehut]

I'm sorry I can't answer your question. Mainly because I have wondered the same thing myself. I never have had much luck with the search feature here. I have tried the quotation marks and it never worked for me.

Well, at least i don't feel like i'm the only one. :) thank you very much for letting me know, and if it ever does end up working, also let me know so i can do my search again.

[CoolHandLuke]

The search is based on word. They have a word table that list all thread with that word in it.

so what they will do is grab the list of thread id that have one word in them, the grad the thread id from the second search index and merge it with the first one and then do the same for word 3,4,...

So they end up doing a query with

where text like %word1%
OR text like %word2%
OR text like %word3%
kind of query that is a inclusive type of item returned

when in fact you would need

where text like %word1 word2%
that is a literal search type.

Maybe there is a way to do it in VBulletin but it's not the double quote if that exist.

The issue with search is that it's a very big database and text search, if not indexed, it can be really slow. This is why they implemented a word table that each time you make a post, they will query each word, add then if it does not exist and if so just add a thread id to the index. Then when searching, they grab each word index unique thread id and merge them to return a array of id needed with a sorting order and this is the result serve.

A bit tech but that is what goes on. In the SCF inventory I do literal search only as this return more reducted result but that is not perfect either.

[Hilfiger1975]

Welcome to SCF!