MYSQL - WILDCARDS

    //WILDCARDS: 
    % LIKE '%ose' LIKE 'Jos%';  /*One or many Characters */   
    _ LIKE 'X_';  LIKE '_X';  /*One Character only*/
    COMBINED: LIKE 'a_%_';  

    REGEXP_LIKE(city, '[b-d]');  /*Containing letters 'b', 'c', or 'd'*/
    NOT REGEXP_LIKE(city, '[b-d]') /*Not containing letters 'b', 'c', or 'd'*/