请问简单的sql语句!

[blueskywjs]

select * from database where mid(name,1,4)='blue'

请问上面的sql语句对不对? 在sql语句中用mid为什么不行?该怎么才能取到name字段的前四个字母?

[eggshell_sy]

用like好象就可以了

[lbd8848]

select * from database where substring(name,1,4)='blue'

[OFFICE之门]

如果后台数据库是SQL SERVER，用：
select * from database where substring(name,1,4)='blue'
如果后台数据库是ACCESS，用：
select * from database where MID(name,1,4)='blue'
或者都用：
select * from database where LEFT(name,4)='blue'

[china_shy_wzb]

select * from database where lift(name,1,4)='blue'

[china_shy_wzb]

select * from database where left(name,1,4)='blue'

[rongyijizhu]

SQL SERVER：
select * from database where substring(name,1,4)='blue'
ACCESS:
select * from database where LEFT(name,4)='blue'