Brock Angelo
Currently viewing the category:
"MySQL"
Delete all the comments marked as spam automatically using cron.
WARNING: All of the recommendations in this post work off of a test database. The following commands could damage your live site if not tested first. Always work off a test site, then perform a database backup before doing any of these things.
I was faced with a challenge at work this week: I wanted [...]
Importing data into a MySQL table from a text file or pasting the new data into the SQL Editor.
Here is how to do a search and replace for a specific Custom Field value in WordPress. Works for all posts that have that value in a specific Custom Field.
Search and Replace MySQL using PHPMyAdmin
This is a life-saver: an easy way to search any table inside your database and replace one string of text with another. It works like a charm. But be careful, search first to see the results of your query before you commit the changes, and always backup prior to [...]
