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