vendredi 13 février 2015

% Wildcard not working with numbers?

I have the following sqlite db:



BEGIN TRANSACTION;
CREATE TABLE `table1` (
`Field1` TEXT
);
INSERT INTO `table1` VALUES ('testing');
INSERT INTO `table1` VALUES ('123');
INSERT INTO `table1` VALUES ('87654');
COMMIT;


This select returns the correct result:



select * from table1 where Field1 like '%e%';


However this one returns nothing?



select * from table1 where Field1 like '%2%';

Aucun commentaire:

Enregistrer un commentaire