SELECT * FROM message WHERE name =

来源：百度知道编辑：UC知道时间：2024/05/16 09:42:40

message.Source = "SELECT * FROM message WHERE name = '" + Replace(message__MMColParam, "'", "''") + "'"
比如我在前面文本框输入“我爱你”那么网页就会找到完全符合此字符的记录。我想要的是把包含此字符的记录都给我找出来。

message.Source = "SELECT * FROM message WHERE name like '%" + Replace(message__MMColParam, "'", "''") + "%'"

完全符合此字符的记录
要这样的只能作用 =
把包含此字符的记录都给我找出来
使用link

name like '%xxxxxx%'

换成like 不行吗

message.Source = "SELECT * FROM message WHERE name like '" + Replace(message__MMColParam, "'", "''") + "'"

SELECT * FROM select from where like select *from 部系表 select sum(*) from...where..... select * from Employees select * from table SELECT * FROM TABLE select ...from之间又有select是什么意思 select * from table1 where id in (select id from table2)， select * into temp from (select * from MESSAGES)，这个对吗？