fork download
copy 
  1. CREATE TABLE test
  2. 	(
  3.  id  int,
  4.  content varchar(30) null,
  5. PRIMARY KEY  (id)
  6.  );
  7.  
  8. INSERT INTO test
  9. (id, content)
  10. VALUES
  11. (1, '10151748418'),
  12. (2, ''),
  13. (3, NULL),
  14. (4, 0),
  15. (5, '10000')
  16. ;
  17. SELECT * FROM test WHERE LENGTH(TRIM( content )) != 0;
Success #stdin #stdout 0s 3360KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
1|10151748418
4|0
5|10000
https://ideone.com/rt6D2A
language:
SQLite (sqlite 3.27.2)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!