Matthew Mullenweg, the creator of WordPress, has a post that shows a nifty SQL statement. First Letters is a simple statement that will return a list that counts the number of records based on the first letter of a specified field. Handy for building a sorting feature based on the first letter (ie. a | b | c | … x | y | z)

Both comments and pings are currently closed.