SELECT only one of multiple entries

[run_GMoney]

Ok, this is kind of hard to explain. I have a field with a list of items. I want to get this list into an array. But I only want one occurence. So if "Harry Potter" is in the field 4 times, I only want one entry. Here's an example:

In my database field:
Lord of the Rings
Harry Potter
Lord of the Rings
Lord of the Rings
Harry Potter
Cujo
The Firm
Lord of the Rings

In my array, I would want 4 items (Lord of the Rings, Harry Potter, Cujo, and The Firm. Is there a fancy SELECT statement that would do that?

[nnichols]

You can do it like this -

SELECT field_name
FROM tbl_name
GROUP BY field_name

or like this -

SELECT DISTINCT field_name
FROM tbl_name

It depends on what other data you are selecting at the same time. Hope this helps 😉

[run_GMoney]

Such a simple solution. Thanks for the response.