Category Archives: MySQL

MySQL: LIMIT the values in the GROUP_CONCAT Function

Posted on July 24, 2011 by Craig Reasbeck

One limitation of the GROUP_CONCAT function is that you can’t directly limit it’s output. Say for example you have an order table and a products table and you wanted to list all the orders for a specific product, you could … Continue reading →

Posted in MySQL | 4 Comments

Finding Duplicate Rows in MySQL

Posted on June 14, 2011 by Craig Reasbeck

I sometimes do some work on an e-commerce website and I needed to find a way to find duplicate products in their database. I didn’t want to use PHP as this was just unnecessary as I just wanted a simple … Continue reading →

Posted in MySQL | 1 Comment