The mySQL query does not return the correct results!

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
                 ";
`

---

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.