not like

    Perform fuzzy matching on the string str, return false if it matches, and return true if it doesn’t match.

    the percent sign (‘%’) represents zero, one, or more characters.

    1. // table test
    2. +-------+
    3. | k1    |
    4. +-------+
    5. | b     |
    6. | bb    |
    7. | a     |
    10. // Return data that does not contain a in the k1 string
    11. mysql> select k1 from test where k1 not like '%a%';
    12. +-------+
    13. | k1    |
    14. +-------+
    15. | b     |
    16. | bb    |
    18. // Return the data that is not equal to a in the k1 string
    19. mysql> select k1 from test where k1 not like 'a';
    20. +-------+
    21. | k1    |
    22. +-------+
    23. | b     |
    24. | bb    |
    26. +-------+

    LIKE, NOT, NOT LIKE