Quick tips: MySql Case
One project I worked on had a table with different spellings between English and French between an individual's title (masculine vs feminine in French). Since I did not want to spend too much time programming in the application itself, I came across the mysql "case" function during research.:
mySQL case is like a switch statement. Check out the official Manual Reference for a more through explanation.
Case When
table1.Gender = 'Female'
Then
table1.titlef
When
table1.Gender = 'Male'
Then
table1.titlem
End AS titlefr
Hope this helps someone else!