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


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