I need a query that shows me a table name in which are last names and names separated by a comma example:
Martinez Nutero, Juan Alberto
and I need you to only show me the value from the comma. I tried this query but it does not work for me. Can someone help me please?
select right(nombre,select locate(',',nombre) from asd_personas) from asd_personas