Capture and parse the array element from shell script

[pho01]

I have a shell script that returns the output of a database query in array. How does array work in shell script? How do I parse and capture the array element?

Thanks,

 

[glx]

Assuming the array is named MYarray


${#MYarray[*]} evaluates to number of array elements
${MYarray[@]} evaluates to all array elements
${MYarray[*]} evaluates to all array elements
${MYarray_{} evaluates to the array element indexed by $sub}