sql条件查询时字段值不区分大小写的写法
2018-07-06 本文已影响10人
HAR余忆
seller_user_name 的实际值为:PCCB201702098439 ,条件输入为 :pCCB201702098439
select * from table where upper(c.seller_user_name) LIKE upper('pCCB201702098439%')
seller_user_name 的实际值为:PCCB201702098439 ,条件输入为 :pCCB201702098439
select * from table where upper(c.seller_user_name) LIKE upper('pCCB201702098439%')