在MySQL行中创建一个NULL字段显示为值？

Question

The only way I can think of doing this is with a bunch of If statements by carrying over the values. Does MySQL currently have a query function that can display a certain value (Lets say, MTNDEW) as another if it falls under the correct qualifications (If ["soda"] = MTNDEW then display it as Mountain_Dew)? Sorry if I'm not being clear, my English is not very good.

Answer 1

you want the mysql if function http://dev.mysql.com/doc/refman/5.5/en/control-flow-functions.html#function_if

SELECT IF(soda='MTNDEW','Mountain_Dew',' NOT Mountain_Dew');