select A.TagName,A.Count,B.TagName,B.Count from Tags A jo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select A.TagName,A.Count,B.TagName,B.Count from Tags A 
join Tags B on B.TagName like concat(A.TagName,'-%') 
and B.TagName != A.TagName
-- is there some better way to do this?
and B.TagName != concat(a.TagName,'-2')
and B.TagName != concat(a.TagName,'-3')
and B.TagName != concat(a.TagName,'-4')
and B.TagName != concat(a.TagName,'-5')
-- not these
and A.TagName not in ('xbox', 'windows')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results