From your question it does not look like you are evaluating Perl approach vs SQL. But anyways here is my take on redundancy - If you want Perl approach, I would use a Hash as tanktalus has mentioned above. This assumes your data is not HUGE! If so then you want keep the information indexed/sorted so that you can check for the key very quickly (also mentioned above).

If you are looking for SQL way then you should consider setting that field as UNIQUE. If you try to update a field that will vioate this unique constraint MYSQL will throw a warning and not update (assuming you will not be using the IGNORE option). If you are updating the data from Perl then you should be able to trap the warning/failure to execute query and report back to the user.  show warnings in MYSQL should give the warning that was generated.

cheers

SK

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.