CODE EXAMPLE FOR SQL

exclude last comma separated string mysql

SELECT SUBSTRING_INDEX('TACOMA, Washington, 98477', ',', 2)