mySQL query not returning correct results!

Question

Hi! This query that I have is returning therapists whose 'therapistTable.activated' is equal to false as well as those set to true! so it's basically selecting all of the db, any advice would be appreciated!

`           $query = "SELECT
                 therapistTable.*
                 FROM
                 therapistTable
                 WHERE
                 therapistTable.activated = 'true'
                 ORDER BY 
                 therapistTable.distance
                 ";              
`

Answer 1

If you're using a boolean type, you should be using TRUE and not'true'. I don't know how that would cause your problem though..

Just to explain: TRUE is an integer (equal to 1), but 'true' is a string.

Answer 2

What is the column type of the column activated, and what are some sample values from the table?

Is it perhaps a BOOL, or some other integer value? 'true' is a string - TRUE is an integer.

If therapistTable.activated is a BOOL, you will want to compare it to TRUE instead of a string.

Answer 3

$query = "SELECT therapistTable.* FROM therapistTable WHERE therapistTable.activated = 'true' ORDER BY therapistTable.distance ";

is correct