I came across this little snippet for querying records where a date field matches today’s date. Using the date function to make sure that only the date portion is returned without the time makes it a quick query that does not require using an external programming language to try and format today’s date correctly for […]
SELECT records with Today’s Date Read More »
I recently worked on a large wordpress blog site that had character encoding problems with the content. It’s not that big a deal to fix one or two instances where you see funny looking characters displayed on the page, but when you have hundreds of them, it’s time to turn to mysql queries to fix
Character Encoding Problems with Content Read More »
Occasionally I have new clients that don’t have access to their control panel, so that a dump of the database cannot easily be performed from a nice GUI interface (Very useful when I want to setup their site for local development). If the server allows executing mysqldump from in php, the following code can be
Using mysqldump to Backup a Database Read More »
I recently had a project where I needed to display all the rows from a mySQL database where the a date field occurred in the current week (From Sunday to Saturday). To keep from building out a complete query in php, I went with a little less complex query all in the SQL query. Using
Get All Rows For the Current Week (Sunday to Saturday) Read More »