I am trying to do the following SELECT statement:
SELECT first_c, substr(first_middle_name, strrpos(first_middle_name, " "), 1) as middle_c, first_middle_name, full_name FROM offenders LIMIT 0,50
It just fails. I need to extract the 1st character after the blank space in the first_middle_name field.
Thanks.