Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: How to match elements of array

by PeterPeiGuo (Hermit)
on Dec 03, 2010 at 03:38 UTC ( [id://875073] : note . print w/replies, xml ) Need Help??

in reply to How to match elements of array

Can make this simpler... I have two alternatives:

1) Create a unique index on file name column, and let the insert fail if it's a duplication.

2) Use SQL in clause, so use one query, you can figure out whether any of those four names exist.

Peter (Guo) Pei