SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `test_table` ( `id` int(11) NOT NULL, `item_name` varchar(225) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8; -- -- Dumping data for table `test_table` -- INSERT INTO `test_table` (`id`, `item_name`) VALUES (1, 'EX CADA '), (2, 'EX CADA '); -- -- Indexes for dumped tables -- -- -- Indexes for table `test_table` -- ALTER TABLE `test_table` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `test_table` -- ALTER TABLE `test_table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 3; COMMIT; SELECT TRIM(item_name) item_name FROM test_table GROUP BY item_name ;