There is a quick query for those of you who have a table full of duplicate values in a MySQL database. Sure, you can remove existing duplicate rows, attempt inserts only for unique values, and setup the table to block duplicate values from being inserted. However, using IGNORE with ALTER TABLE has drawbacks and you may want to tailor a DELETE statement instead. Know the risks and get your queries.
Here is a helpful function for WordPress theme designers and developers. You can remove the Featured Image controls when creating a post, in case you have something custom that you want to use.
Get the function
If you need to search for and replace text in a database column, MySQL provides a built in method similar to other scripting languages. Get the syntax.
