特殊sql【二】限制、排序

[sql] view plain copy print ?

1. -->UPPER LOWER   
2. select BIZ_CATALOG from biz_shop where UPPER(BIZ_CATALOG)='CINEMA';  
3. select BIZ_CATALOG from biz_shop where LOWER(BIZ_CATALOG)='cinema';  

-->UPPER LOWER select BIZ_CATALOG from biz_shop where UPPER(BIZ_CATALOG)='CINEMA'; select BIZ_CATALOG from biz_shop where LOWER(BIZ_CATALOG)='cinema';

把数据库值转换大写或小写 进行比较  

[sql] view plain copy print ?

1. -->   
2. select SHOP_sid from biz_shop where shop_sid like '_e%'  

--> select SHOP_sid from biz_shop where shop_sid like '_e%'

查找第二个字母是e的列

[sql] view plain copy print ?

1. -->转义符   
2. select SHOP_sid from biz_shop where shop_sid like '\_e%' escape '\';  

-->转义符 select SHOP_sid from biz_shop where shop_sid like '\_e%' escape '\';
not and or 优先级 依次排列

orcal 查询语句无序 同样的sql语句 查询出的结果顺序可能不同