Okay, so I've got a MySQL database here that I'm working with that is already pre-populated with data.
Only thing is - the guy that designed the structure set it up in such a way where one of the rows in a table which should contain numeric data actually contains string data...
Think "six" instead of 6.
Luckily there are only ten different possibilities...so everything is either "one", "two", "three", "four", "five", etc...up to "ten"
Problem is - I need to do a comparison in my query.. Kindof like "WHERE row <= whatever".
How would you go about approaching this? Is there a way to do 10 conditionals in MySQL to say
if row = "ten" row = 10?
Thanks in advance!