Tag Archives: case when condtion is perfect for integer field but not for varchar

CASE When Not working with varchar (default value null) in mysql.. please check the solution

create a table using the below sql statement

if we use the below mysql query output as like below

you can see the result with NULL value for the first_name field. if you use the query as in a newformat ..with IFNULL condition it wil work. below query will work for you SELECT… Read More »