Determining if an array element exists

Determining if an array element exists and has a value is a task that can be done using the ARRAY_EXISTS function.

1. Define an IF statement:
   1. Define a condition that includes the ARRAY_EXISTS function.
   2. Specify the THEN clause and include any logic that you want to have performed if the condition is true and add any ELSE caluse values you want.
   3. Close the IF statement with the END IF clause.
2. Execute the IF statement.

phones		index		0		           1		           2		           3 				
         phone		'416-223-2233'	'416-933-9333'	'416-887-8887'	'416-722-7227'

IF (ARRAY_EXISTS(phones, 2)) THEN
  SET x = 1;
END IF;