mysql --left 写法

  SELECT
            *
FROM
    your_table
        WHERE
            is_deleted = 0
          AND phone_number = #{account}
          AND LEFT ( check_time, 10 ) = #{date} 
        ORDER BY check_time

check_time 值2024-07-02 19:43:30