MySQL SELECT question

vargadanis · 10-10-2006, 06:35 PM

Hi,

I would like to select datas from a table but it often contains the same "title" (with different other fields). I would like to select only once those rows that has the same title field. Eg:

Code:

ID  |  TITLE  |  POST_ID
-------------------------
 1  | Apple   |  4
 2  | Apple   |  9
 3  | Cherry  |  11

In this case I want to select the fields with Apple title only once. Is it possible?

paulsm4 · 10-10-2006, 06:36 PM

"select unique"

PS:
Some databases (like mySQL) use "distinct" instead of "unique".

Quote:

EXAMPLE:
select distinct address_city from center_addresses order by address_city;

vargadanis · 10-10-2006, 07:08 PM

Ahha...

I tried but it just listed everything again:

Code:

SELECT DISTINCT * FROM phpbb_topics INNER JOIN phpbb_posts ON phpbb_topics.topic_id=phpbb_posts.topic_id  ORDER BY -phpbb_posts.post_time LIMIT 3

What do u think what shall I edit to get it working?

chrism01 · 10-10-2006, 08:14 PM

select distinct (title), blah, blah
distinct * tries to apply it to every unique combination

vargadanis · 10-10-2006, 09:00 PM

Ok... I solved it with your help. The new code is:

Code:

SELECT DISTINCT phpbb_topics.topic_title, phpbb_topics.topic_id FROM phpbb_topics INNER JOIN phpbb_posts ON phpbb_topics.topic_id=phpbb_posts.topic_id  ORDER BY -phpbb_posts.post_time LIMIT 3

I know that it doesn't say much for those who do not know what tables I was using. If you are interested in visit phpbb.com and install the forum engine.