like

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

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

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

    LIKE