Sql like query that ignore the first word completely

Question

I want the sql like query that ignores the first word from the field completely, I want remaining word.

For example: Name:
John Smith
ABC XYZ PQR

Output :
Smith
XYZ PQR

I want the string after the first (whitespace)

Thanks in advance.

Answer 1

Try this:

SELECT RIGHT(Name, LENGTH(Name) - LOCATE(' ', Name))
FROM mytable

Function LOCATE returns the position of the first occurrence of space inside the column (if any). Using RIGHT we can easily extract the part that comes right after this space occurrence.

Answer 2

Just use it.

SELECT SUBSTRING(name, LOCATE(' ', name)+1) FROM mytable

*name = Field Name,

*mytable= Table Name