I have a question that can we use a mysql query in Concat clause. I want to make a query like this
SELECT CONCAT(AVG(value),'-',(select Count(UserId) as counts from user_details )) as `Average` from surveyuseranswer
Now I want to count number of users and concat it with the average value. My query runs but it returns me nothing. Can anyone help me that where I am wrong.
Thanks in advance.