模糊查询-like
格式:
SELECT Columns_1,Columns_2,Columns_n FROM TABLE WHERE Columns_3 LIKE ' '
示例:
包含“国”
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '%国%';
“张”开头
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '张%';
“国”在中间
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '%国_';
“国”结尾
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '%国';
“张”开头 两个字
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '张_';
“张”开头 三个字
SELECT USER_ID,USER_CODE,USER_NAME FROM XY_USER WHERE USER_NAME LIKE '张__';