select first character of second word (surname) - MySQL Snipplr Social Repository

Revision: 21814

at December 22, 2009 03:48 by ReeceMarsland

Initial Code

SELECT SUBSTRING( reverse( TRIM( node.title ) ) , locate( ' ', reverse( TRIM( node.title ) ) ) -1, 1 ) AS title_truncated
FROM node

Initial URL

Initial Description

Initial Title

select first character of second word (surname)

Initial Tags

mysql

Initial Language

MySQL