SELECT questions, COUNT(*) AS howmany FROM yourtable GROUP BY questions HAVING howmany > 1 #### ALTER IGNORE TABLE yourtable ADD UNIQUE KEY (questions)