mysql,sql查询问题，谢谢解答

Question

1.SELECT MTAUT_ID,MTAUT_PARID FROM MT005AUT WHERE MTAUT_ID = 'MT10011'

2.SELECT MTAUT_ID,MTAUT_PARID,MTAUT_NAME,MTAUT_ADDRESS FROM MT005AUT WHERE MTAUT_PARID LIKE 'MT10000,MT10011%'

第1次查询是想获取MTAUT_PARID,然后在通过MTAUT_PARID去查询和这个值相关的数据，如何能把这两个语句并成一条语句写呢？谢谢解答

可能是我表述有问题，你们看到那个百分号没？

Answer 1

 SELECT MTAUT_ID,MTAUT_PARID,MTAUT_NAME,MTAUT_ADDRESS FROM MT005AUT WHERE  MTAUT_PARID = (SELECT MTAUT_ID,MTAUT_PARID FROM MT005AUT WHERE MTAUT_ID = 'MT10011') and MTAUT_PARID LIKE 'MT10000,MT10011%'