In the form A, B, C, D four columns, stored values are Numbers, data type is text,

Hope to get the query result is A> B and C> 1 and D> Line 0

Use the select * from TABLE where A> B and C> 1 and D> 0;

The returned result is satisfied C> only; 1 and D> 0

A<=B line also return together, this is not the result of I need

Using the select * from TABLE where A> B and select * from TABLE where C> 1 and D> Zero check out of the results are normal

For the correct query statement

CodePudding user response:

Why save digital use text types

CodePudding user response:

reference 1/f, the breeze gently up response:

save digital why want to use the text type

Embarrassed, build table when copy books copied wrong, then do a few simple query didn't appear what problem, I haven't changed