MySQL 自学第十一章 使用数据处理函数

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、数值处理函数