in reply to Re: DBD::Mysql select
in thread DBD::Mysql select

Thanks for those suggestions. I need to search for names that are a certain length (eg 5,6 characters) aswell. Can this be done using mysql?

Replies are listed 'Best First'.
Re^3: DBD::Mysql select
by davorg (Chancellor) on Sep 04, 2006 at 15:10 UTC

    Don't mean to sound rude, but did you consider looking in the documentation?

    SELECT some_columns
FROM   some_table
WHERE  CHAR_LENGTH(some_column) = 5

    [download]
    --
    <http://dave.org.uk>

    "The first rule of Perl club is you do not talk about Perl club."
    -- Chip Salzenberg

[reply]
[d/l]

In Section Seekers of Perl Wisdom