SQL删除a开头b结尾的信息

表：student字段：studentID,username,password，hobby,address,sex,age

2025-03-26 05:34:07

推荐回答（4个）

回答1：

应该是
delete from student where username like 'a%' and username like '%b'

like 'a%b'这种不行的。如'abc' 也会删掉

回答2：

具体哪个字段啊？
比如username字段：
delete from student t where t.username like 'a%b' ;

回答3：

比如username字段：
delete from student t where left(t.username,1)='a' and rihgt(t.username,1)='b'

回答4：

delete from student where username like ('a%b');

最新问答