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

  • one
    Read about Normal Forms. This is not very good at storing data. - Oleg Arkhipov
  • one
    Description drove into a stupor o_O - Palmervan
  • is the word distinct? - alexlz
  • @Construct data can be stored in the event that - let's say, separated by a comma, the same labels and LIKE are indicated in the request) - Palmervan
  • one
    @blud. select id, count(*) from tab group by id . But how to deal with the rest of the table depends on what you want to receive. - alexlz

1 answer 1

 SELECT DISTINCT * FROM table