I have a problem in making a query to make virtual columns in my query. I want to make a query that makes virtual column. for example I have a table with columns a,b and c and I want to make a query something like this
SELECT a as acolumn,b as b column,c as ccolumn,d as doesnotexist in table. and the d column does not select anything but it displays as a column. Is this possible in mysql.
Thanks in advance