I am new-is to SQL. I am working in MySQL Workbench. I am trying to use the function UNNEST() to pull data from arrays of strings in a column of the table I am working on, but when I type UNNEST() into the query console, there is a squiggly red line under the first parenthesis with the error:
"(" is not valid at this position; expecting EOF, ';'
What does this mean? Why can't I use the UNNEST function? I tried using it in the FROM statement and as a CROSS JOIN. No matter where the UNNEST() is, the first parenthesis gets this error.