springboot整合MyBatis报错：Operand should contain 1 column(s)

springboot整合MyBatis报错：Operand should contain 1 column(s)

        select
            (id,user_id,ticket,status,expired)
        from login_ticket
        where ticket = #{ticket}
    

报错原因

select后面不要括号

        select
            id,user_id,ticket,status,expired
        from login_ticket
        where ticket = #{ticket}
    

这样就不会出错了
sql语句要记牢！