Thursday, November 8, 2012

NULL check in SQLite

When you want to select only the data where comment is not null, you can use this command.
SELECT * from timeobject where comment != ""; 

References

http://stackoverflow.com/questions/7519621/where-is-null-not-working-in-sqlite

No comments:

Post a Comment