CASE
WHEN LENGTH(t4.authoropenid)<10 THEN (SELECT streetname FROM sys_user WHERE user_id=t4.authoropenid)
ELSE t4.authornickname
END AS replya,
判断字符串长度执行语句
CASE
WHEN LENGTH(t4.authoropenid)<10 THEN (SELECT streetname FROM sys_user WHERE user_id=t4.authoropenid)
ELSE t4.authornickname
END AS replya,
判断字符串长度执行语句