How to pull data from an array using SQL

If I have a string column with the following data:

+-------+----------------------------+
| Row # |        Array Column        |
+-------+----------------------------+
|     1 | {apple;coconut;mango}      |
|     2 | {coconut;pear;grapes}      |
|     3 | {strawberry;mango;coconut} |
|     4 | {}                         |
|     5 | {january}                  |
+-------+----------------------------+

How can I pull out only the rows that have mango or nothing in it?

Result:

+-------+----------------------------+
| Row # |        Array Column        |
+-------+----------------------------+
|     1 | {apple;coconut;mango}      |
|     3 | {strawberry;mango;coconut} |
|     4 | {}                         |
+-------+----------------------------+

SELECT * 
FROM YourTable 
WHERE ArrayColumn='{}' 
OR ArrayColumn like '%mango%'

SELECT * 
FROM YourTable 
WHERE size(ArrayColumn)=0
OR array_contains(ArrayColumn,'mango')