SELECT f8 FROM “人员导入标准模板”
WHERE f8 = 30 OR f8 IS NULL;
SELECT f8 FROM 人员导入标准模板
WHERE f8 = 30 OR f8 IS NULL;
SELECT f7, f8 FROM 人员导入标准模板
WHERE f8 BETWEEN 30 AND 80 AND f7 = ‘女’ AND some_column IS NULL
ORDER BY f7, f8 DESC
LIMIT 15;
SELECT f7, f8 FROM 人员导入标准模板
WHERE f8 BETWEEN 30 AND 80 AND f7 = ‘女’
ORDER BY f7, f8 DESC
LIMIT 15;
SELECT f3,f4 FROM 人员导入标准模板
WHERE f4 LIKE ‘%刘%’
ORDER BY f4;
SELECT f3,f4 FROM 人员导入标准模板
WHERE f3 REGEXP ‘[123]’
ORDER BY f4;
SELECT f3,f4 FROM 人员导入标准模板
WHERE f3 REGEXP ‘[1-3]’
ORDER BY f3;
现在我们要只有123用in
SELECT f3, f4 FROM 人员导入标准模板
WHERE f3 IN (‘1’, ‘2’, ‘3’)
ORDER BY f3;
然后我们要匹配符号就用\\
SELECT f3,f4 FROM 人员导入标准模板
WHERE f3 REGEXP ‘[:digit:]{3}’
ORDER BY f3;
SELECT f3,f4 FROM 人员导入标准模板
WHERE f3 REGEXP ‘[0-9][0-9][0-9]’
ORDER BY f3;
SELECT CONCAT(f4,'(‘,f7,’)’) FROM 人员导入标准模板
ORDER BY f4;
SELECT f6*f8 AS Safetyindex
FROM 人员导入标准模板
WHERE f8 = 30
ORDER BY f6,f8;