Query not working properly; record is not fetched based on chracter string query

Help
1

In table “T”, column “lobe” is defined as Varchar(10). lobe is populated with values like (3/4, 5/6, 7/8) etc. but select * from T where lobe = ‘5/6’ is not returning any value?! Altered the datatype of “lobe” to LONGTEXT still no luck! Running the query in MYSQL workbench. Gurus urgent help is deeply appreciated…

2

Hi, can you give us a more precise example. I wouldn’t recommending doing this (comparing varchars to decimal), but it does work:

MemSQL [test]> create table t(c1 varchar(10));

MemSQL [test]> insert into t values (3/4);

MemSQL [test]> select * from t where c1 = 3/4;
+------------+
| c1         |
+------------+
| 0.75000000 |
+------------+