mySQL

mySQL Tidbits: GROUP_CONCAT and ON DUPLICATE KEY UPDATE Examples

Some of the trickiest queries involve a GROUP_CONCAT or a cascade. Here are some use cases and tips.

Read more

mySQL Find and Replace throughout Entire WordPress Database

We use this every time we migrate from a development domain to the live domain. Don’t let old development links sneak away from you again!

Read more