Tag Archives: Bug

MySQL bug related with natural number order fix

It seems that this is a known bug but I only noticed it yesterday.

Imagine you have a field named price and it’s type is VARCHAR (it doesn’t matter why it’s not INT or FLOAT) and you want to use ORDER BY clause so you can list table rows ordered by price value.

It won’t work, since the prices will be listed alphabetically, you may read here how to fix this issue.

Continue reading