title: Displaying same data once in MySQL
body: <p>So I have a table named files with the following values</p>
  <blockquote>
  <p>File Name   | End User Name<br>
  file1              |            CNS<br>
  file2              |            CNS<br>
  file3              |            CNS<br>
  file4              |            EndUser2<br></p>
  </blockquote>
  <p>As you can see, the end user name is same. So what I want to do is basically display the end user name once and add a button that shows the list of all the files containing the end user name &quot;CNS&quot;. I want &quot;CNS&quot; to display once only, being a column of &quot;files&quot; table.</p>
  <blockquote>
  <p>End User Name | Files<br>
  CNS                             | View Files<br>
  EndUser2               | View Files<br></p>
  </blockquote>
  <p>I'm confused about what query will I use to display the same end user names only once.</p>