select

[swampy]

Is it possible to perform a mysql query that only returns unique items. For example:

Record # | Field
1 | hello
2 | goodbye
3 | hello
4 | hi

Returns:

1
2
4
but not 3 because it has already been found.

Thanks

Rob

[brandonschnell]

select id, distinct word from table;

[[deleted]]

SELECT id_field, string_field
FROM table
GROUP BY string_field
HAVING count(*) = 1;