I was building a QA spreadsheet the other day, where I needed to generate a number of randomly-generated WordPress posts with the posts’ titles, URLs, admin URLs, and publication date to be shared with the client via Google Drive, and needed my SQL query to generate links that could readily be pasted into the spreadsheet.

Continue reading→