sql语句的书写问题(20分)

Y

ynxdlj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-01

• #1

我想用SQL语句查询列值的前3位是‘123’的符合条件的记录，SQL语句应如何书写，请大家
帮忙！

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-01

• #2

select * from tbalename where fieldname like '%123'

 

L

LeeChange

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-01

• #3

select * from tablename
where FieldName like '123%'

 

S

svw0506

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-01

• #4

select * from tablename where FieldName like '123%'
或
select * from tablename where substr(fieldname,1,3)='123'
(第二条用Oracle)

 

Y

ynxdlj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-01

• #5

多人接受答案了。