mysql,查询语句的问题，谢谢。

Question

SELECT
max(MTAUT_INDEX)，MTAUT_PARID
FROM
MT005AUT
WHERE
LOCATE('MT10000', MTAUT_PARID) > 0

我想查询mtaut_index的最大值，还得同时mtaut_parid里包含mt10000的值，这个语法好像不对，哪位帮帮忙，谢谢

SELECT * FROM MT005AUT WHERE
LOCATE('MT10000', MTAUT_PARID) > 0 and MTAUT_INDEX=(SELECT max(MTAUT_INDEX) FROM MT005AUT)

Answer 1

SELECT MTAUT_INDEX，MTAUT_PARID
FROM
MT005AUT
WHERE
LOCATE('MT10000', MTAUT_PARID) > 0
order by MTAUT_PARID desc limit 1