Select '5 !', count(*) from posts where postTypeId=1 and ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

Select '5 !', count(*) from posts where postTypeId=1 and title like '%!!!!!'
union
Select '4 !', count(*) from posts where postTypeId=1 and title like '%!!!!'
union
Select '3 !', count(*) from posts where postTypeId=1 and title like '%!!!'
union
Select '2 !', count(*) from posts where postTypeId=1 and title like '%!!'
union
Select '5 ?', count(*) from posts where postTypeId=1 and title like '%?????'
union
Select '4 ?', count(*) from posts where postTypeId=1 and title like '%????'
union
Select '3 ?', count(*) from posts where postTypeId=1 and title like '%???'
union
Select '2 ?', count(*) from posts where postTypeId=1 and title like '%??'

Enter Parameters

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