The WHERE function seems broken. For example, the following code returns all records, when I only want to see those where ‘status’ (a TINYINT) is zero thru five:
SELECT * FROM
WHERE ‘status’ <6
What am I doing wrong?
(actually, it’s only six that I don’t want. But, I get the same result -all records- with =4, =5, =6, <>6, !=6, etc.)
I’ve found lots of ways to get a syntax error, but isn’t this right?
Further, "WHERE ‘client’ = also returns all records, and ‘client’ is a text field. What am I doing wrong?