Tag: mysql

MySQL: Group By Column And Include Its Count

Without going into too much detail about the why, consider the below table. It’s a snippet of a table I’m working with for an e-commerce site. Any user (user_id) can have different products (product_id), but any user can also have

Posted in: Code Samples, Development  |  Tagged with:  |  Leave a comment

WordPress: How To Update Site URL And Home URL Using SQL

I do this often enough. You think it’d be committed to memory by now. Alas, my memory doesn’t need to be bothered with things like this. That’s what my blog is for. So here blog, remember this. I also, like

Posted in: Development  |  Tagged with: , , ,  |  Leave a comment