I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be having a
problem doing queries where with '' to search a number.
for instance if I do the following
select ring_time fron calls where ring_time '10';
I get the following results
3
6
3
6
3
6
2
3
3
3
2
etc.
Why?
This row is
I'm fairly certain that it's because when you're saying ring_time
'10', it's asking sqlite to take all strings that are greater than the
string '10'. So all the numbers you presented are greater than 1. What
you want is where ring_time 10. Notice the lack of quotes which
means treat 10 as