SELECT stStateName,stCityName,stUrlSlug,stStateAbbr FROM tbl_states WHERE stStateName LIKE 'South-carolina' AND stCityName LIKE 'Charleston'