How to get only single results from MySQL?

There is a field in the table, and in this field there are a lot of different values and they can be repeated, I need to pull out the results, but if they are repeated, then output only once. There is even a specific syntax for this for Select. Tell me, please.


Answer 1, authority 100%

SELECT DISTINCT * FROM table

Leave a reply

Please enter your comment!
Please enter your name here