its just simple where condition, but its working getting all data from the data table. Not considered the value false
select * from `api_auth` where `auth_key` = false;
Asked
Active
Viewed 58 times
0
-
1Try using `auth_key IS FALSE` – Viki888 Jan 05 '17 at 13:41
-
2@Viki888 Why??? `SELECT 1 = 0 = false; -> 1 ` – Strawberry Jan 05 '17 at 13:42
-
Remove auth_key out of the single inverted commas – Prashanth Benny Jan 05 '17 at 13:43
-
2@PrashanthBenny Why??? – Gurwinder Singh Jan 05 '17 at 13:43
-
Because it is considering your column as a string..... – Prashanth Benny Jan 05 '17 at 13:44
-
2@PrashanthBenny There's no inverted commas here. – Strawberry Jan 05 '17 at 13:44
-
2@PrashanthBenny you are talking about backticks and they are used only to escape mysql reserved words if used as a table/column name. Here are useless but harmless – Lelio Faieta Jan 05 '17 at 13:45
-
what is the data type of the `auth_key` column? – ADyson Jan 05 '17 at 13:47
-
data type of the auth_key column **text** – Kalidass Jan 05 '17 at 13:52
-
Ops.... My bad.... – Prashanth Benny Jan 05 '17 at 13:53
-
If it's text, probably using = 'false' would fix... Right? Sql considers false as Boolean probably... – Prashanth Benny Jan 05 '17 at 13:54
-
@PrashanthBenny you means problem with sql ? – Kalidass Jan 05 '17 at 14:00
-
not a problem with sql.... its a wrong interpretation..! – Prashanth Benny Jan 05 '17 at 14:26
-
@LelioFaieta my bad! my misinterpretation :D – Prashanth Benny Jan 05 '17 at 14:37
-
1@KalidassP if you have a column which you are using to represent true and false, then the "text" data type is not really a good choice. Some better suggestions here: http://stackoverflow.com/questions/289727/which-mysql-datatype-to-use-for-storing-boolean-values – ADyson Jan 05 '17 at 15:09
-
@KalidassP did the issue get fixed? – Prashanth Benny Jan 06 '17 at 06:27
1 Answers
1
Here, the issue seems to be with the wrong usage of false in this statement as a Boolean datatype.
Since the datatype of auth_key column is text as you have mentioned as an answer to @ADyson, and you have used the Boolean false to compare the string datatype in the column, MySql is not populating the results as you require.
comparing you text column with a matching datatype(i.e., string) would fix the error.
i.e.,
select * from `api_auth` where `auth_key` = 'false';
Prashanth Benny
- 1,523
- 21
- 33
-
whilst the solution will work, I dispute this statement: "wrong interpretation of false as a keyword or Boolean datatype by MySql compiler." MySQL is interpreting it correctly as the boolean literal FALSE (see https://dev.mysql.com/doc/refman/5.7/en/boolean-literals.html). But that boolean value is not equal to the text string "false", hence why it doesn't restrict the results as the OP wants. The real issue of course, is that OP is abusing the "text" data type to store boolean values and should use another more suitable data type. – ADyson Jan 05 '17 at 15:12
-
-
@ADyson i have edited the answer! hope it means the same :) . i am a bit bad in articulation! please forgive.... – Prashanth Benny Jan 05 '17 at 15:43
-