Question

关于VB中的like语句的使用

ElseIf Cmb2.Text = "相似" Then
mysqls = mysqls + " Like """ + Txt2.Text + """"
请帮我指出哪里出错了。。。谢谢

Answer 1

" Like """ + Txt2.Text + """"

改为

" Like '*" + Txt2.Text +"*'"

===============
如果
1.mysqls ="select * from user where username1 "
2.Txt2.Text 的内容是 "123"
那么你的sql拼接起来就是
"select * from user where username1 Like ""123"""
正确的是
"select * from user where username1 Like '123'"
因为是like 所以要加*