advanced code snippet search

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
 
Expand | Embed | Plain Text 
  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.