MySQL 4.0.13-nt
I have a table:
CREATE TABLE state_county (
StCo_key bigint(20) NOT NULL auto_increment,
State varchar(255) NOT NULL default '',
County varchar(255) NOT NULL default '',
Territory bigint(20) NOT NULL default '0',
Hits bigint(20) NOT NULL default '0',
PRIMARY KEY (StCo_key,State),
UNIQUE KEY StCo_key (StCo_key),
KEY State (State),
KEY StCo_key_2 (StCo_key)
) TYPE=MyISAM;
When I execute the any of these queries:
SELECT `StCo_key` , `State` , `County` , `Territory` , `Hits`
FROM `state_county`
WHERE `State` = 'Iowa'
SELECT *
FROM `state_county`
WHERE `State` = 'Iowa'
SELECT *
FROM `state_county`
WHERE `State` = "Iowa"
I get an empty set. If I execute:
SELECT *
FROM `state_county`
WHERE `StCo_key` = "1"
I get the result.
What do I need to do to get the `State` querey to work?
TIA,
Paul