sqlite where clause returns no rows -

sqlite 3.6.13

.schema runs yields

create table runs (id integer primary key,                 runname    text default 'norun',                .... 

executing

select runname runs order runname desc limit 10;   *returns*  2015ww27.3c 2015ww27.3b 2015ww27.3a 201528.3c 201528.3b 201528.3a 201528.2z 201528.2y 201528.2x 201528.2s 

but executing

select runname runs runname = '210528.2y'; 

doesn't fail doesn't return 1 row expected.

i've pulled out of hair on - field declared text single-quotes appropriate use. what's wrong here?

tia,

still-learning steve

you have chars flipped around. you're asking runname doesn't exist. (at least data says @ least.)

edit:

maybe meant write

20158.2y 

instead of

21058.27