• ornek
    select RTRIM(REVERSE(SUBSTRING(REVERSE('www.local.com/abc/ccs/12-345-6789'),LOCATE('-',REVERSE('www.local.com/abc/ccs/12-345-6789'))))) ;

    update
    update table name set column_name RTRIM(REVERSE(SUBSTRING(REVERSE(column_name),LOCAT E('-',REVERSE(column_name)))))
  • SELECT SUBSTRING("www.com/12-34-5678",1, (CHAR_LENGTH("www.com/12-34-5678") - LOCATE('-', REVERSE("www.com/12-34-5678")))) as a;


    update table_name set column_name = SUBSTRING(column_name ,1, (CHAR_LENGTH(column_name ) - LOCATE('-', REVERSE(column_name ))))