re: DISTINCT on one collum

2002-12-20 Thread Egor Egorov
On Friday 20 December 2002 13:35, Steve Vernon wrote: > MySQL as the filter stupidly does not match SELECT > > Hiya, > How do you get a disctinct value from one collumn only? I am basically > using it to construct a dynamic menu, and need the menu names at a level. > > Items are in one tab

DISTINCT on one collum

2002-12-20 Thread Steve Vernon
MySQL as the filter stupidly does not match SELECT Hiya, How do you get a disctinct value from one collumn only? I am basically using it to construct a dynamic menu, and need the menu names at a level. Items are in one table, like CATEGORY, SUBCATEGORY, SUBSUBCATEGORY, PAGE, ID I cou