LIKE查询,语法:SELECT FROM table_name WHERE condition LIKE condition;
    例子:SELECT
    FROM timiadc WHERE hero_name LIKE ‘%孙%’;
    (这里的空格用了制表符)
    ‘%孙%’表示含有孙的,’孙%’以孙开头的,’%孙’以孙结尾的。
    下划线(

    image.png
    AND & OR
    语法:SELECT FROM table_name WHERE conditionA AND/OR condtionB;
    例子:
    image.pngimage.pngimage.png
    IN/NOT IN
    语法:SELECT
    FROM table_name WHERE column IN (condtionA,condtionB);
    查询热度为“T0”和“T3”的英雄,语句:
    SELECT
    *
    FROM
    timi_adc
    WHERE
    fever IN ('T0', 'T3');
    NOT IN/NOT LIKE
    否定,例子:
    SELECT
    *
    FROM
    timi_adc
    WHERE
    fever NOT IN ('T0');
    注意:只有一个条件也需要括号。NOT LIKE 一样,例子:
    SELECT
    *
    FROM
    timi_adc
    WHERE
    hero_name NOT LIKE '%孙%';
    NULL值处理:NULL 对应NOT NULL,NULL并不是空,且占据空间。
    image.png语法:
    SELECT field_name1,field_name2
    FROM table_name
    WHERE field_name2 IS NOT NULL/IS NULL;