模糊查询 进................(0分)

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-28

• #1

摸糊查询 怎么写?
是不是这样写?
select * from table1 where name like %edit1.text%

 

C

chinargb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-28

• #2

可以用如下：
format('select * from table1 where namw like '+'''%s''',['%'+Edit1.text+'%'])

 

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-28

• #3

啊 这样？？？在DELPHI里面怎么写？

 

C

ChrisMao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-11-30

• #4

QueryActive := False;
with Query.SQL do begin
Clear;
Add(Format('Select * From Table Where Field Like ''%%%s%%''', [edtValue.Text]));
end;
Query.Active := True;