Tag Archives: mysql

MySQL select rows between months

Let’s say you want all rows from a table that have a date between next month and the next 3 months, MySQL provide us (since 4.1) a beautiful LAST_DAY function (for the record there is no FIRST_DAY…. at least yet), … Continue reading

Posted in Geek Stuff | Tagged , , | 3 Comments

Mysql split column string into rows

A MySQL recipe, that you can use to split a cell value by a known separator into different rows, in some way similar to the PHP explode function or split in PERL. To turn this: id value 1 4,5,7 2 … Continue reading

Posted in Geek Stuff | Tagged , , , , , | 22 Comments