2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

Get the second part of the string from given string

I have column like

jon miller

andy campbell

i want to get the second part of the name

userimage
select substr(name,instr(name,' ',1,1)+1)  from table_name;
Answer is