MySQL select where column is not empty

by

Compare value of phone2 with empty string:

select phone, phone2 
from jewishyellow.users 
where phone like '813%' and phone2<>''

Note that NULL value is interpreted as false.

More Related Contents:

  1. MySQL Insert query doesn’t work with WHERE clause
  2. Delete from two tables in one query
  3. Why would an IN condition be slower than “=” in sql?
  4. PostgreSQL GROUP BY different from MySQL?
  5. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  6. Fulltext Search with InnoDB
  7. MySQL dump by query
  8. MySQL’s now() +1 day
  9. Delete sql rows where IDs do not have a match from another table
  10. Rewriting mysql select to reduce time and writing tmp to disk
  11. How do I convert from BLOB to TEXT in MySQL?
  12. Can you access the auto increment value in MySQL within one statement?
  13. Which SQL query is better, MATCH AGAINST or LIKE?
  14. What does DELIMITER // do in a Trigger?
  15. Mysql: how to select groups having certain values?
  16. How to create a multi-tenant database with shared table structures?
  17. MySQL #1140 – Mixing of GROUP columns
  18. Boolean vs tinyint(1) for boolean values in MySQL
  19. MySQL full text search for words with three or less letters
  20. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  21. Function for week of the month in mysql
  22. MySQL’s alternative to T-SQL’s WITH TIES
  23. Find rows that have the same value on a column in MySQL
  24. what is the difference between GROUP BY and ORDER BY in sql
  25. What does collation mean?
  26. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  27. sql pulling a row for next or previous row of a current row
  28. Row Rank in a MySQL View
  29. Select Rows with Maximum Column Value group by Another Column
  30. mysql GROUP_CONCAT duplicates

Leave a Comment