dongyi8795 2016-09-25 05:58
浏览 790
已采纳

选择具有多个不等于where子句的语句

In my MySQL i have user_role_id column

I want to select all from the table tbl where user_role_id is not equal to 1, 4 and 5

Till now i use only for single not equal like

select * from tbl where user_role_id != 4

Kindly help me with the syntax for multiple not equal

  • 写回答

1条回答 默认 最新

  • dongliehuan3925 2016-09-25 06:03
    关注

    You can use the NOT IN Constraint for that which is available in the MYSQL.

    NOT IN() function:

    MySQL NOT IN() makes sure that the expression proceeded does not have any of the values present in the arguments

    Example: If you want to fetch the rows from the table book_mast which contain such books, not written in English and the price of the books are not 100 or 200, the following statement can be used.

    SELECT book_name,dt_of_pub,pub_lang,no_page,book_price  
    FROM book_mast        
    WHERE pub_lang!="English"     
    AND book_price NOT IN (100,200);
    

    Reference: https://www.techonthenet.com/mysql/not.php

    As per your code you need to change the query like.

    "SELECT * FROM tbl WHERE user_role_id NOT IN (1, 4, 5)"
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?