Really really easy. Say you need all records of a column / field to be unique so that you can add Unique Index to that field. For instance, you have a field named ‘url’. To select out a unique selection of all different ‘url’ you can try:
SELECT title, url, platform, cheat, letter FROM `game` GROUP BY url
To create new table with this:
CREATE TABLE newtable SELECT * FROM `game` GROUP BY url ORDER BY id
or if the table is created:
INSERT INTO newtable SELECT * FROM `game` GROUP BY url ORDER BY id