Hi, I created a database in Mysql called test, and I creates a table called test_sites
with this script :
create table test_sites (
id int(5) NOT NULL PRIMARY KEY,
name varchar(200) NOT NULL,
link varchar(200) NOT NULL,
category varchar(200)
);
insert into test_sites(id, name, link, category) values (1, "Arthur Andersen", "http://www.arthurandersen.com/", "Audit Firms");
.......more lines
But when I type :
mysql> select * from test_sites;
I can see all the rows, but for some queries (mysql> select * from test_sites where category = "Travel";
Empty set (0.00 sec) )I go empty set even I can see them with "select * from test_sites;"
with this script :
create table test_sites (
id int(5) NOT NULL PRIMARY KEY,
name varchar(200) NOT NULL,
link varchar(200) NOT NULL,
category varchar(200)
);
insert into test_sites(id, name, link, category) values (1, "Arthur Andersen", "http://www.arthurandersen.com/", "Audit Firms");
.......more lines
But when I type :
mysql> select * from test_sites;
I can see all the rows, but for some queries (mysql> select * from test_sites where category = "Travel";
Empty set (0.00 sec) )I go empty set even I can see them with "select * from test_sites;"