Can you do If/Then statements in Mysql? If so a little help would be appreciated (a brief example). Basically, I want to create a new variable with a certain value depending on the relationship between two other variables.
If you can't do this, I'm sure there is some way around this using queries. Is this the case?