Skip to content
Home » MySQL


MySQL open source database

Converting MySQL tables to UTF-8

Quick and easy code to convert the character set of a MySQL table to UTF-8. Of course this works for all character sets not just UTF ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;


Just a quick reminder and example to myself really for this useful MySQL string function. Syntax: REPLACE( table_field, search, replace) Example (replaces all instances of donkey with horse: UPDATE `table` SET `table_field` = REPLACE( `table_field`, ‘donkey’, ‘horse’)

Find Duplicate Rows Query

Here’s an SQL query that’ll return all the duplicate rows in your table. SELECT `id`, COUNT(*) as `dup` FROM `table_name` GROUP BY `id` HAVING `dup` > 1 ORDER BY `dup`