0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

-- Tags starting with non-alpha characters

select Posts.Id as [Post Link] from Posts, PostTags, Tags
where substring(Tagname, 1, 1) = '#'
and Posts.Id = PostTags.PostId and PostTags.TagId = Tags.Id;

--select First
--from (select substring(Tagname, 1, 1) as First from tags) as s
--group by First
--order by First;

fork query

created aug 9 10 sth