MySQL中SELECT命令大家都经常在用，下面为您介绍的是MySQL中SELECT命令的几种特殊用法，供您参考学习之用。

MySQL中SELECT命令类似于其他编程语言里的print或者write，你可以用它来显示一个字符串、数字、数学表达式的结果等等。如何使用MySQL中SELECT命令的特殊功能？

1.显示MYSQL的版本

mysql>selectversion(); 
+-----------------------+ 
|version()| 
+-----------------------+ 
|6.0.4-alpha-community| 
+-----------------------+ 
1rowinset(0.02sec) 

2. 显示当前时间

mysql>selectnow(); 
+---------------------+ 
|now()| 
+---------------------+ 
|2009-09-1522:35:32| 
+---------------------+ 
1rowinset(0.04sec) 

3. 显示年月日

SELECTDAYOFMONTH(CURRENT_DATE); 
+--------------------------+ 
|DAYOFMONTH(CURRENT_DATE)| 
+--------------------------+ 
|15| 
+--------------------------+ 
1rowinset(0.01sec) 
 
SELECTMONTH(CURRENT_DATE); 
+---------------------+ 
|MONTH(CURRENT_DATE)| 
+---------------------+ 
|9| 
+---------------------+ 
1rowinset(0.00sec) 
 
SELECTYEAR(CURRENT_DATE); 
+--------------------+ 
|YEAR(CURRENT_DATE)| 
+--------------------+ 
|2009| 
+--------------------+ 
1rowinset(0.00sec) 

4. 显示字符串

mysql>SELECT"welecometomyblog!"; 
+----------------------+ 
|welecometomyblog!| 
+----------------------+ 
|welecometomyblog!| 
+----------------------+ 
1rowinset(0.00sec) 

5. 当计算器用

select((4*4)/10)+25; 
+----------------------+ 
|((4*4)/10)+25| 
+----------------------+ 
|26.60| 
+----------------------+ 
1rowinset(0.00sec) 

6. 串接字符串

selectCONCAT(f_name,"",l_name) 
ASName 
fromemployee_data 
wheretitle='MarketingExecutive'; 
+---------------+ 
|Name| 
+---------------+ 
|MonicaSehgal| 
|HalSimlai| 
|JosephIrvine| 
+---------------+ 
3rowsinset(0.00sec) 

注意：这里用到CONCAT()函数，用来把字符串串接起来。另外，我们还用到以前学到的AS给结果列’CONCAT(f_name, " ", l_name)’起了个假名。