How to skip blank data in MySQL?

Question

I wanted to skip blank data in MySQL.

My sample query is:

SELECT id, name, date from sample where name IS NOT NULL;

Sample table:

id     name         date
1                  24-04-2012
2      abc         23-04-2012

Now if I fire above query, it gives me both record but I want to skip data which is stored as blank i.e. There is nothing(not even NULL)?

So how can I skip 1st record? What should be my query?

So how to skip blank data in MySQL?

Please guide me.

Do you mean a blank string? NULL literally means "nothing". – Ste Apr 24 '12 at 13:16 — Ste, Apr 24 '12 at 13:16
Yes..how can I skip 1st record from sample table? – Prat Apr 24 '12 at 13:17 — Prat, Apr 24 '12 at 13:17

mellamokb · Accepted Answer · 2012-04-24T14:02:27.720

19

You can eliminate both NULL and empty/blank strings from your results using the following:

 where name IS NOT NULL AND name <> ''
                        ^^^^^^^^^^^^^^ add this

Edit: As pointed out in the comments, trim is not even necessary.

edited Apr 24 '12 at 14:02

answered Apr 24 '12 at 13:16

mellamokb

3

`TRIM()` isn't necessary since string comparison with `<>` doesn't consider trailing spaces in MySQL. – Marcus Adams Apr 24 '12 at 13:32
1

@Marcus is correct, `TRIM()` is not needed in this case (in MySQL). – ypercubeᵀᴹ Apr 24 '12 at 13:33

score 2 · Answer 2 · edited May 23 '17 at 12:24

2

This question is already solved by mellamokb, but here I propose a one way step based on "How to check if a parameter is null or empty sql" and NULLIF mySQL function:

where  nullif( trim(name) , '') is NULL

edited May 23 '17 at 12:24

Community

answered Apr 24 '12 at 13:29

dani herrera

score 0 · Answer 3 · answered Apr 24 '12 at 13:18

0

SELECT id, name, date from sample where trim(name)

answered Apr 24 '12 at 13:18

Robin Castlin

Simply have column name as mentioned above. It will get validated since it's not a blank string -> `` – Robin Castlin Apr 24 '12 at 13:20
Then it is showing both records...I don't want record with blank data. – Prat Apr 24 '12 at 13:21

3 Answers3