SELECT by non-primary key

Databases
1

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

2

The field is defined as being numeric but you are telling it to look for a string. Try removing the quotes around the number.

3

my first guess is because there actually aren`t any rows in your table with that providerid

4

Yes, that was it, thx