各数据库取左N个字符查询

楼主 spiderman 于 2014-03-27 10:48:38
各数据库取左N个字符查询
[P]mysql:[/P][P]select id,left(title,5) as title from leadbbs_announce limit 5[/P][P]
[/P][P]mssql[/P][P]select top 5 id,SUBSTRING(title,1,5) as title from leadbbs_announce [/P][P]access:[/P][P]SELECT TOP 5 id, Mid(title,1,5) AS title
FROM leadbbs_announce
[/P]
回复
1 　

电脑版 Page created in 0.0625 seconds with 4 queries.