急sql语句，在网页中检索数据库的英文，语句要怎么写啊？
select id,class_name from class_en where class_name like '% "&keys& "% ' order by id desc
这样写不可以哦，注：class_name 字段里是英文
------解决方案--------------------
如果要拼接语句
是
"select id,class_name from class_en where charindex( ' " & keys & " ',class_name)> 0 order by id desc "