MySQL数据处理函数

文本处理函数：

//upper转换大写
select vend_name, upper(vend_name) as vend_name_upcase 
from vendors 
order by vend_name;

//匹配所有发音类似于Y.Lie的联系名
select cust_name, cust_contact 
from customers 
where soundex(cust_contact) = soundex( 'Y .Lie');

日期和时间处理函数：

select cust_id, order_num 
from orders 
where date(order_date) = '2005-09-01';

select cust_id, order_num 
from orders 
where date(order_date) between '2005-09-01' and '2005-9-30';

select cust_id, order_num 
from orders 
where year(order_date) = 2005 and month(order_date) = 9;