--以a开头的数据 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE 'A%' --以Z结尾的数据 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE '%Z' --含有B的数据 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE '%B%' --不含有B的数据 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME not LIKE '%B%' --三位且中间字母是a的 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE '_a_' --两位且结尾字母是a的 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE '_a' --两位且开头字母是a的 SELECT * FROM BCUSTOMER_MZN WHERE CST_NAME LIKE 'a_'