OK..let me get this straight. You're querying a database to get all usernames so you can use Perl to see if a given username is present?

If that's the case -- and this isn't a rather odd homework assignment -- make the database do the work and write the query to see if the username is present. This way Perl would get a true/false answer from the database, and you wouldn't have to check 8,000,000 usernames

In Perl, one way to do it would be to load all the usernames into an array and use grep

$yes = grep { /$username/ } @usernames;

[download]

emc

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.

Albert Einstein

In reply to Re^3: accessing values in hash by swampyankee
in thread accessing values in hash by mattdope

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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! —
  • 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:
    & &amp;
    < &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.