Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select query always empty when using where
The LIKE command works fine, it was just SELECT WHERE that didn't. All sorted now though: It seems to be something with the way the textfile was imported. I initially did it using the command LOAD DATA INFILE, and got the above errors. Last night I downloaded mysqlfrontend from zdnet, and... -
Select query always empty when using where
sure, table name = aircraft fields aircraft_id varchar(10) manufacturer varchar(50) model varchar(50) mark varchar(20) a query of select * from aircraft; returns= |"air693" | "Vickers Supermarine" | "Spitfire" | "LF IX B"... -
Select query always empty when using where
I have imported my data ok, as when I run the query select * from tablename; all the records are displayed ok. However if I try the query select * from tablename where columnname = "condition"; I get the message empty set, even though I can see the condition from the first query...
