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  

Comments

RSS Icon Subscribe to comments
Posted By: on February 4, 2019

download best software to android root use app kingo or 360 for pc mac ios windows 10 8 1 7 xp computer http://www.wuxingshijia.com/home.php?mod=space&uid=9990

You need to login to post a comment.