if statement inside a query?

[onedumbcoder]

Is it possible to have an if statement inside a query?

 

something like this:

 

SELECT IF type = 0 THEN 'car' AS t ELSEIF type = 1 THEN 'bike' AS t FROM machine WHERE ownser='mike'

[corbin]

http://dev.mysql.com/doc/refman/5.0/en/case-statement.html

[Ken2k7]

SELECT IF(type=0,'car','bike') AS t
FROM machine
WHERE ownser='mike'

 

That should work.