select * from tbl_name where fields_name like '%公司%'
"select * from tbl_name where fields_name like '%" &trim(txt.text)& "%'"
看楼主写的语法格式,大概是打算在客户端里面访问数据库吧? libin_ftsafe(子陌红尘) 写的是在SQL里面可以用的,格式上可能有点问题。呵呵同意 vivianfdlpw()的写法。三句分别是: "select * from tbl_name where fields_name like '%" & str &"%'" "select * from tbl_name where fields_name like '%" &trim(txt.text)& "%'" "select * from tbl_name where fields_name like '%公司%'"
"select * from tbl_name where fields_name like '%" & str &"%'"
"select * from tbl_name where fields_name like '%" &trim(txt.text)& "%'"
"select * from tbl_name where fields_name like '%公司%'"