自学第十一章 使用数据处理函数
1、文本处理函数
SELECT vend_name, Upper(vend_name) AS vend_name_upcase FROM vendors ORDER BY vend_name;
SOUNDEX是一个将任何文本串转换为描述其语音表示的字母数字模式的算法。
SELECT cust_name, cust_contact FROM customers WHERE cust_contact = 'Y.Lie';
SELECT cust_name, cust_contact FROM customers WHERE Soundex(cust_contact) = Soundex('Y.Lie');
常用文本处理函数
2、日期和时间处理函数
SELECT cust_id, order_num, order_date FROM orders WHERE Date(order_date) = '2005-09-01';
SELECT cust_id, order_num, order_date FROM orders WHERE Date(order_date) BETWEEN '2005-09-01' AND '2005-09-30';
SELECT cust_id, order_num, order_date FROM orders WHERE Year(order_date) = 2005 AND Month(order_date) = 9;
3、数值处理函数