sql中select...where 语句(50分)

D

Dchou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-13

• #1

若name1='abcdefg'，以name1为参，怎样选出name包含在name1中的记录
如table1.name=bcd, 'select * from table1 where name...' 要怎样写?

 

W

wjiachun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-13

• #2

'select * from table1 where '+''''+name+''''+' ...'

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-13

• #3

adoquery1.close;
adoquery1.SQL.Text:='select * from table1 where :str like ''%''+trim(name)+''%''';
adoquery1.Parameters.ParamByName('str').Value:='abcdefg';
adoquery1.open;

判断库中所有的记录是不是 字符串s的子串
http://www.delphibbs.com/delphibbs/dispq.asp?lid=1238661

 

D

Dchou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-13

• #4

多人接受答案了。