Originally posted by Son Nguyen
I have a table like this:
CREATE TABLE reg_school (
id int(10) unsigned NOT NULL auto_increment,
country varchar(50) NOT NULL default '',
name varchar(255) NOT NULL default '',
activate tinyint(4) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY country (country,name),
KEY activate (activate),
FULLTEXT KEY country_2 (country)
) TYPE=MyISAM COMMENT='';
and a query like this
"SELECT * FROM reg_school WHERE country LIKE 'C%' ORDER BY country,name"
And for some reason, the first row starts with a C and the next row is an A. Anyone knows why is that?
mysqladmin Ver 8.40 Distrib 4.0.13, for pc-linux on i686
Thanks for any help
Hi, It could not be the presence of a blank space before ' C' due to the SELECT statement force the field to start with a 'C' as well if you see a country which name begins with a different caracter than a 'C' in the result of your query then you should try to recreate the table.