Sql.Add('Select name from sometable where name like ''%英%''')
select name from table_name where name like %英%
Query1.sql.clear; Query1.sql.add('select * from table1 where name like ''%英'''); Query1.sql.open;//注意%号位置可前可后,也可用两个,如%英%
Query1.sql.add('select * from table1 where name like "%英%"');
select * from table1 where name like'%英%'
query1.close; query1.sql.clear; query1.sql.add('select * from table where name like ''%英%'''); query1.prepare; query1.open; 注意:''%英%''中引号应为两对单引号,而不是一对双引号.
Query1.sql.add('select * from table1 where name like ''%英''');
Query1.sql.open;//注意%号位置可前可后,也可用两个,如%英%
query1.sql.clear;
query1.sql.add('select * from table where name like ''%英%''');
query1.prepare;
query1.open;
注意:''%英%''中引号应为两对单引号,而不是一对双引号.