求一条SQL语句:查询条件为字符前段相同从table1表中sel
从tae1表中select出a1列(字符型) 满足:a1中的数据满足前面的几个字符与变量ch相同 ch、a1的长度都不确定
asp:"select a1 from table1 where a1 like '" & ch & "%'" php:"select a1 from table1 where a1 like '" . $ch . "%'" 其他:"select a1 from table1 where a1 like '"+ch+."%'"