use strict;
use warnings;
use DBIx::Class;

my $rs = $schema->resultset('YOURTABLENAMEHERE')->search(
{},
  {
    columns => [ qw/name/ ],
    distinct => 1
  }
);

my $count = $rs->count;
[download]

PerlMonks lovingly hand-crafted by Tim Vroom.
PerlMonks somehow became entangled with The Perl Foundation.
Wonderful Web Servers and Bandwidth Generously Provided by pair Networks
Built with the Perl programming language.