Select Count(Id), Len(Title) FROM Posts GROUP BY Len(Title)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

Select Count(Id), Len(Title) 
FROM Posts 
GROUP BY Len(Title) 
HAVING Len(Title) = (SELECT Max(Length)
FROM (SELECT Len(Title) as Length FROM Posts) as Long) 
OR Len(Title) = (SELECT Min(Length)
FROM (SELECT Len(Title) as Length FROM Posts) as Short)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results