SQLServer like和charindex()实现模糊查询

//sql语句
Create table Users(username varchar(20) primary key,password varcahr(20)
)

1、like 实现模糊查询

select * from Users where username like "%123%"

2、charindex()实现模糊查询

select * from Users where charindex(username,'1234,567')>0