/*
模糊查询,使用通配符
_下划线代表任意一个字符,该符号只能匹配一个字符
%百分号表示0个或多个字符,即任意长度的字符串
[]表示范围
^[^]表示不属于范围,即范围取反
*/
select * from myUsers where userName like '%[1-2]%'
select * from myUsers where userName not like '%[1-2]%'
select * from myUsers where userAddress like '%[^1-2]'
select * from myUsers where userName like '%[^1-2]%'
select * from myUsers where userName like '%[刘_久_]%'
select * from myUsers
/*
更新操作
update 表名 set 字段名1 = 值
update 表名 set 字段名1 = 值,字段名2 = 值
update 表名 set 字段名1 = 值,字段名2 = 值 where 条件
*/
update myUsers set userName = '赵六哥哥' where userName = '赵1六'
update myUsers set userAddress = userAddress + '人民', userName = userName + '测试'
update myUsers set userAddress = subString(userAddress, 0, 100),
userName = userName + '测试'
where userName like '%二狗子%'