Below is the correct syntax.
SELECT STR_TO_DATE(c.date, '%d/%m/%y') AS parsed_date FROM concertlistts AS c;
https://dbfiddle.uk/xkWalE9c