MySQL how can I get the value of all rows with the same value once?

Question

Table
--------
| col1 |
--------
|  A   |
--------
|  A   |
--------
|  A   |
--------
|  B   |
--------
|  B   |
--------
|  C   |
--------

How can I get values A, B, C?

Solution

Using a distinct query can accomplish your goal.

SELECT DISTINCT(col1) FROM `Table`;

Comments

[user145989]

How du I make this not a duplicate, the problem is completely different? 1. When you try install by UEFi 64 bit Ubuntu you never see the windows partition. That is the first problem.

[user145989]

Yes that was what I discovered, I I asssume there is no tutorial you can follow to dual-boot Ubuntu 13.04 and windows8 64 bit uefi installation??

[user145989]

I finally solved the problem))))

[user145989]

I finally solved the problem)))) The problem was to disable secure boot and still have UEFI enabled. I did not seem to find any solution to seperate theese two things. But I read something interesting about ACER boot menues and they said you need to set a password in bios menu to be able to disable the Secure boot. So I tried that. And I was suddenly able to disable the secure boot. I restarted the computer, and ran BOOT-repair and followed all instructions given by Boot-repair. Then restarted and finally the Windows 8 was bootable just as Ubuntu 13.04