SELECT * FROM TableName WHERE FieldName LIKE '%模糊%'
/* SQL语句怎么查,Delphi里就怎么查 */ ADOQuery1.Close;
ADOQuery1.SQL.Text := Format(
'SELECT * FROM TableName WHERE FieldName LIKE '%s',
[QutoedStr('%' + Edit1.Text + '%')]);
ADOQuery1.Open;
/* SQL语句怎么查,Delphi里就怎么查 */ ADOQuery1.Close;
ADOQuery1.SQL.Text := Format(
'SELECT * FROM TableName WHERE FieldName LIKE '%s',
[QutoedStr('%' + Edit1.Text + '%')]);
ADOQuery1.Open;
adoquery1.sql.clear;
sql:='select * from yourtable where username like '%'+edit1.text+''%';
adoquery1.sql.add(sql);
adoquery1.open;
begin
close
sql.clear;
sql.add('select * from yourtable where username like ''%'+Trim(edit1.text)+'%''');
open;
end;