参考答案: D
详细解析:
正确答案D A contains使用方法不准确，语法错误 B 完全匹配不是模糊匹配 C选项适合用rlikeA. select* from user where username contains(‘vip')
B. select* from user where username='vip'
C. select* from user where username like *vip*
D. select* from user where username like'%vip%'
参考答案: D
详细解析:
正确答案D A contains使用方法不准确，语法错误 B 完全匹配不是模糊匹配 C选项适合用rlike