方法1
SELECT s1.userid ,s1.truename ,s1.mobile ,
CASE s2.roleid
WHEN '0' THEN
'家長'
WHEN '1' THEN
'導師'
WHEN '2' THEN
'教育機構'
WHEN '3' THEN
'大聯盟'
ELSE
'新导师'
END AS 'roleid'
from
member_detail as s1
LEFT JOIN sl AS s2 ON s1.userid = s2.userid
#这个位置可以加where 条件
order by
s1.userid
limit 0 , 20
方法2
select pagesetroleidone,if(pagesetroleidone=14262,"男","女") from 1688_pagesets where pagesetroleidone = 14262