How do I run a search on array

Hi,

I've been trying to do:

select col1 from table while array_col[1][1:4]='2';

how do I do this sort of thing? There seems to be no docs ;-(

my array is {{"1","2","4","2"},{"3","2","5"},{"6","3","7","9"}}

I would also like to know that if I have an array as a large object, is it
possible to do a search on it using rows and columns (or by any other
way)?

thanks,
Indraneel

/************************************************************************.
# Indraneel Majumdar ¡ E-mail: indraneel(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/