Posted By

ReeceMarsland on 12/22/09


Tagged

mysql substring


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

virendrakryadav


select first character of second word (surname)


 / Published in: MySQL
 

  1. SELECT SUBSTRING( REVERSE( TRIM( node.title ) ) , LOCATE( ' ', REVERSE( TRIM( node.title ) ) ) -1, 1 ) AS title_truncated
  2. FROM node

Report this snippet  

You need to login to post a comment.