I have a table
CREATE TABLE IF NOT EXISTS `reviews` (
`id` smallint unsigned NOT NULL auto_increment,
`from` varchar(50) NOT NULL,
`length` varchar(20) NOT NULL default '',
`date` date NOT NULL,
`providerid` smallint unsigned NOT NULL,
PRIMARY KEY (`id`)
);

I'm trying to make a query on it that would select a row depending on the providerid
select * from reviews where providerid = '39';
but nothing is returned, why is this?

Thanks