MYSQL Search

[cekirge]

ok i am trying to make a search engine like ebay,
when they search for an item, i want to display the categories the auctions belongs too(the top level ones with the number of times occured),
my structure is like
id, cat_id, parent_id, name for categories
how can i do it?
any ideas

[planetsim]

Try Looking at LIKE in the MySQL Manual

[cekirge]

i probably couldnt explain it right,
let me explain it with an example
lets say people are searching for games
the search returned auctions in
Toys, Games & Hobbies > Action Figures > Toy Soldiers
Toys, Games & Hobbies > Action Figures > Sports
Video Games > Classic > Atari
I want to find out how many results returned in Toys, Games & Hobbies and Video Games etc.
I can find how many results in the category itself and parent category, but i dont know how to find the very very top levels