Tag Archive: mysql

Dec 26

Explode string in MySQL

If you know your PHP there is this nifty function called explode which allows you to turn an string into an array by splitting it. quite sure Javascript has a similar function called split which you call from a string like an object. Now if you wanted to do the same thing in MySQL you’d …

Continue reading »

Dec 26

MySQL Number Sequence Generator

So we know that we can use the following to generate a sequence of numbers during a SELECT from a table but this works because our variable’s value is being altered for every row we get from our SELECT so what do we do when we have when we want a sequence but no table …

Continue reading »