Select Count(Id) as Posts, Len(Title) as Length FROM Post...

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) as Posts, Len(Title) as Length 
FROM Posts 
GROUP BY Len(Title) 
HAVING Len(Title) = (SELECT Max(Len(Title))
FROM Posts) 
OR Len(Title) = (SELECT Min(Len(Title))
FROM Posts)
                      

SELECT Max(Len(Title)) as Longest, Min(Len(Title)) as Shortest
FROM Posts

Enter Parameters

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