In this query, I want to change the output of the "TYPE" field to only output the name in the TYPE field to the first letter of what is there.
SELECT TYPE, COUNT(*) AS count
WHERE NODENAME IN ('TSG','COSTAR','STE') AND CURDATE >= '2006102'
GROUP BY TYPE
If the query comes back with the following names in the TYPE field, I want them changed to their first character in the query output.
ADD_TO = A
IMMED = I
OK2GO = O
How do you suggest I accomplish this?