CREATE TABLE test
(
id int,
content varchar(30) null,
PRIMARY KEY (id)
);
INSERT INTO test
(id, content)
VALUES
(1, '10151748418'),
(2, ''),
(3, NULL),
(4, 0),
(5, '10000')
;
SELECT * FROM test WHERE LENGTH(TRIM( content )) != 0;
Q1JFQVRFIFRBQkxFIHRlc3QKCSgKIGlkICBpbnQsCiBjb250ZW50IHZhcmNoYXIoMzApIG51bGwsClBSSU1BUlkgS0VZICAoaWQpCiApOwoKSU5TRVJUIElOVE8gdGVzdAooaWQsIGNvbnRlbnQpClZBTFVFUwooMSwgJzEwMTUxNzQ4NDE4JyksCigyLCAnJyksCigzLCBOVUxMKSwKKDQsIDApLAooNSwgJzEwMDAwJykKOwpTRUxFQ1QgKiBGUk9NIHRlc3QgV0hFUkUgTEVOR1RIKFRSSU0oIGNvbnRlbnQgKSkgIT0gMDs=