Pages

Showing posts with label SQLite. Show all posts
Showing posts with label SQLite. Show all posts

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