MySQL identical fields

How can I get MySQL to discount identical fields?

[yumigator]

My CMS is coming along, but I've run into a problem.

My system gives each item a unique id (auto_increment). Each item is also identified by its title. There may be more than one page in an item; in that case, each page gets its own row. As a result, there are some rows that have identical titles. The unique id is not used by my script and is merely there to ensure no two rows are identical.

I want now to be able to create a list of all my items, but the catch is I don't want items with multiple pages to be listed more than once. Only the first page in an item shall be displayed.

Is there any way with MySQL or PHP to filter the extra rows out such that when everything is processed, there is only one instance of each title in my list?

This is for the backened, so I'm not really concerned with the number of queries, but is there an efficient way to do this?

[Pico_Train]

Select DISTINCT title from pages where title = $title ?

[Jaunty Edward]

Select * from pages group by title order by id

that will show each title once and you can show the first or last item with the same title by using order by id desc or asc

Regards,
Jaunty

[yumigator]

Thanks, those both work well. I never could have found those on Google :D.

I ended up using the GROUP BY method, because after some searching I ran across COUNT(), which would even let me display how many pages were in each item.

Thanks again!