How to get from the database ALL values ​​of column "A" WHERE "B" = "far"?

Question

PHP

There is something similar:
SELECT А FROM table WHERE В = far
This query produces only 1 matching row.
How to get everything?

Answer 1

Most likely only one line and matches the condition, or alternatively you are using the wrong function to get the result, try PDO fetchAll or fetch_all

Answer 2

Did you watch? Your request does exactly what is described in the title. If the query produces only one row, then there is only one row in the table and there is one with a satisfying condition ( B = far)