mysql的between的边界取值,范围取值

    xiaoxiao2023-11-16  182

    MySQL中BETWEEN是包含两边界值的,表示在此范围内,并且包含此值 SELECT * FROM users WHERE user_id BETWEEN 1 AND 3

    =》SELECT * FROM users WHERE user_id >=1 AND user_id <=3 2. MySQL中NOT BETWEEN 是不包含两个边界的,表示不在此范围内

    SELECT * FROM users WHERE user_id NOT BETWEEN 2 AND 4

    =》SELECT * FROM users WHERE user_id <2 AND user_id >4

    最新回复(0)