SQL has a wide array of String manipulation functions, but there are a few you want to get to know right away
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
LEFT()
RIGHT()
MID()
SUBSTR()
Carter-Hernandez-Yang
Carter-Hernandez-Yang
Carter-Hernandez-Yang
Carter-Hernandez-Yang