Categories: select up to two for your listing % item match
Collectibles > Animation Art, Characters > Japanese, Anime > Sanrio, Hello Kitty > Hello Kitty > Other Items 36%
Collectibles > Animation Art, Characters > Japanese, Anime > Other Japanese, Anime 9%
Music > CDs 8%
Toys & Hobbies > TV, Movie, Character Toys > Hello Kitty > Other 9%
Clothing, Shoes & Accessories > Women's Accessories, Handbags > Handbags, Bags 6%
Collectibles > Animation Art, Characters > Animation Characters > Hello Kitty 6%
DVDs & Movies > DVD & HD DVD 5%
Books > Children's Books 4%
Searching -- Like ebay
Moderator: General Moderators
- tecktalkcm0391
- DevNet Resident
- Posts: 1030
- Joined: Fri May 26, 2006 9:25 am
- Location: Florida
Searching -- Like ebay
How does ebay do the search for your category where if you type hello in it returns:
- tecktalkcm0391
- DevNet Resident
- Posts: 1030
- Joined: Fri May 26, 2006 9:25 am
- Location: Florida
I dont think it could be done in pure SQL. This is off the top of my head, but heres what I'm thinking:
1. Search for items containing the keyword searched for
2. Count the total number of keywords found in all results
3. Divide each items keyword count by the total keyword count, to find it's percentage.
This would be a very simple method for sorting by relevancy, and I'm sure ebay has a much more complicated method.
1. Search for items containing the keyword searched for
2. Count the total number of keywords found in all results
3. Divide each items keyword count by the total keyword count, to find it's percentage.
This would be a very simple method for sorting by relevancy, and I'm sure ebay has a much more complicated method.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA