return the column that contains only value without white spaces

Question

Name column contains space.I tried to fetch the column rows which contains only names and should not return null values and empty values.But it return the column which contain white spaces. I tried:

select name,id from details where name is not null;

The above query return the data contains white spaces. how to eliminate the data that contain white space in it?

did you checkout this answer looks similar https://stackoverflow.com/questions/6969315/mysql-query-to-return-rows-that-contain-whitespace — Umakanth, Sep 20 '17 at 05:56

score 0 · Accepted Answer · answered Sep 20 '17 at 05:57

0

try to use the NOT LIKE syntax ; change your query to the following:

select name,id from details where name is not null and name not like '% %'

you can check this answer.

answered Sep 20 '17 at 05:57

MrMisery

406
7
19

there might be somewhere else in your query or code you need to check , because I have tested this. – MrMisery Sep 20 '17 at 06:02
you're welcome, try to mark it as the correct answer since it works. – MrMisery Sep 20 '17 at 06:08

score 0 · Answer 2 · answered Sep 20 '17 at 06:06

0

Try trim function:

select name,id from details where name is not null and trim(name) <> '';

answered Sep 20 '17 at 06:06

Blank

12,308
1
14
32

score 0 · Answer 3 · edited Sep 20 '17 at 06:44

0

This may work for you.

select name, id 
from details 
where name is not null and name !=""

edited Sep 20 '17 at 06:44

Fabrizio

7,603
6
44
104

answered Sep 20 '17 at 06:07

Abhishek Singh

701
6
5

Thank you ExDev for formatting my code, As this is my first contribution. I will take care from next time. :) – Abhishek Singh Sep 20 '17 at 06:51

return the column that contains only value without white spaces

3 Answers3