[Phpmyadmin-devel] Using Case or If statement

[Rick Beach]

When creating a view in phpmyadmin on yahoo business I need to know the corrct syntax to return text. Below are two examples of an If statement and a case statement that return an Integer. Both of these views work correctly. There are also three examples of an If statement to return text and three examples of case statements to return text. None of these six examples work correctly even when using using single quotes, double qoutes or no quotes at all. Please review all of the below examples and let me know what is happening that the select statement changes.

SELECT If(Month(Now())=2,555,999)
   works correctly

SELECT case Month(now()) when 2 then 555 else 999 end
   works correctly

SELECT If(Month(Now())=2,'Feb','Oth')
   changes the select statement to:
      SELECT If(Month(Now())=2,\'Feb\',\'Oth\')
   and gives error:
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\',\'Oth\')' at line 5

SELECT If(Month(Now())=2,"Feb","Oth")
   changes the select statement to:
      SELECT If(Month(Now())=2,\"Feb\",\"Oth\")
   and gives error:
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\",\"Oth\")' at line 5

SELECT If(Month(Now())=2,Feb,Oth)
    gives below error:
      #1054 - Unknown column 'Feb' in 'field list' 


SELECT case Month(now()) when 2 then 'Feb' else 'Other' end
   changes the select statement to:
      SELECT case Month(now()) when 2 then \'Feb\' else \'Other\' end
   and gives error:
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\' else \'Other\' end' at line 5 

SELECT case Month(now()) when 2 then "Feb" else "Other" end
   changes the select statement to:
      SELECT case Month(now()) when 2 then \"Feb\" else \"Other\" end
   and gives below error:
      #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\" else \"Other\" end' at line 5

SELECT case Month(now()) when 2 then Feb else Other end
   gives below error:
      #1054 - Unknown column 'Feb' in 'field list'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20120208/4bfc28c7/attachment.html>