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%')
本文标题：sql条件查询时字段值不区分大小写的写法
本文链接：https://www.haomeiwen.com/subject/cnevuftx.html
网友评论