need to see each original input in field

[cliff7376]

i have a problem i have a database where i have 100,000 records. i want to be a ble to query one field in the table. i only want to see the data in that field that is original from anyother data in the field. for instance if the word "bend" is in the field 5,000 times i only want to see it once in my query. any ideas.

 

[araskas]

Use 'DISTINCT' clause. Search for help on this and you will find plenty of examples on it.

SELECT DISTINCT(myfld) FROM
myTable ;