Using C#.Net and MYSQL
I want to use a CASE Statement like SQL
Query
SELECT vehicleno,
brandname,
CASE
WHEN inexpire < 0 THEN 'Expired'
ELSE inexpire
END AS inexpire
FROM (SELECT Concat(plateno, vehicleno) AS vehicleno,
brandname,
Datediff(inedate, Curdate()) AS inexpire
FROM tb_car
WHERE inedate < DATE_ADD(Curdate(), INTERVAL 30 DAY)
GROUP BY vehicleno) AS tab1
When I run the Query it is showing a output as
System.Byte[] instead of Expired
In the above query inexpire is column values
How to solve this issue.....
Need Query Help