mySQL returns all rows when field=0

by

This is because it is converting the email field (which I assume is a varchar field) to an integer. Any field without a valid integer will equate to 0. You should make sure that you only compare string fields to string values (same goes for dates, comparing to dates). The query should be as follows.

SELECT * FROM table WHERE email="0";

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. How can I select data from different tables?
  3. Select all columns except one in MySQL?
  4. SELECTING with multiple WHERE conditions on same column
  5. MySQL Query – Records between Today and Last 30 Days
  6. Ordering by specific field value first
  7. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  8. What is MySQL row order for “SELECT * FROM table_name;”?
  9. Select mysql query between date?
  10. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  11. mysql select from n last rows
  12. MySQL select with CONCAT condition
  13. Checking multiple columns for one value
  14. Sort by order of values in a select statement “in” clause in mysql
  15. Mysql select distinct
  16. Return a default value if single row is not found
  17. How to select one row randomly taking into account a weight?
  18. MySQL – Select the last inserted row easiest way
  19. How to add a where clause in a MySQL Insert statement?
  20. Sum results of a few queries and then find top 5 in SQL
  21. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  22. Syntax error when using except in a query
  23. SQL query to check if a name begins and ends with a vowel
  24. Using index, using temporary, using filesort – how to fix this?
  25. MySQL : retrieve a large select by chunks
  26. MySQL – insert data from another table merged with constants
  27. Insert data into table with result from another select query
  28. How to SELECT by MAX(date)?
  29. MySQL matching unicode characters with ascii version
  30. MySQL: how to index an “OR” clause

Leave a Comment