直接将a定义为变量
set n='a'
select album, aritst as @n from CD where album like '%' + @n + '%'
go

SQL query: Documentation

SET n = 'artist' SELECT album, artist AS @n
FROM CD
WHERE album LIKE '%' + @n + '%'

MySQL said: Documentation

#1193 - Unknown system variable 'n'

这样不可以啊

我没明白你的意思。。。。下面是按我的理解写的
select album, aritst from CD where album like '%aritst%'
你看这样行吗？

select album, aritst as a from CD where album like '%'+aritst+'%'

希望能帮助到你!