[SOLVED] ! Not Empty help with query?

[Mr Chris]

Hi Guys,

 

Wondering if someone can help me with a query that’s confusing me.  If I want to check for empty values on a column I’d do:

 

Select * FROM results
WHERE team_one_score !='  '
LIMIT 1;

 

Which is fine, but trying to run this query via a joined table:

 

SELECT th.team_name, ta.team_name, r.team_one_score, r.competition, r.fixture_id, r.team_one_id, r.team_two_id
FROM results r
INNER JOIN teams th ON r.team_one_id = th.team_id
INNER JOIN teams ta ON r.team_two_id = ta.team_id
WHERE r.team_one_score !=' '
AND team_one_id='1' OR team_two_id='1'
LIMIT 1;

 

My query ignores the empty rule? 

 

Can anyone help?

 

Thanks

 

Chris

 

[Illusion]

!='  ' is not empty value it is equal to two spaces if u want to check for NULL values u need to give the condition like !='' or team_one_score is NULL.

[Mr Chris]

Thanks,

 

But that was my typo and i've tried Null as well:

 

SELECT th.team_name, ta.team_name, r.team_one_score, r.competition, r.fixture_id, r.team_one_id, r.team_two_id
FROM results r
INNER JOIN teams th ON r.team_one_id = th.team_id
INNER JOIN teams ta ON r.team_two_id = ta.team_id
WHERE r.team_one_score != Null
AND team_one_id='1' OR team_two_id='1'
LIMIT 1;

 

And

SELECT th.team_name, ta.team_name, r.team_one_score, r.competition, r.fixture_id, r.team_one_id, r.team_two_id
FROM results r
INNER JOIN teams th ON r.team_one_id = th.team_id
INNER JOIN teams ta ON r.team_two_id = ta.team_id
WHERE r.team_one_score !=''
AND team_one_id='1' OR team_two_id='1'
LIMIT 1;

 

And yet it still ignore's the NOT empty rule?  Any other ideas please?

 

Thanks

[Illusion]

that should be

 

WHERE r.team_one_score IS NOT NULL

 

and

 

WHERE r.team_one_score=''

 

it all depends on how u inserted the values in that column if u inserted NULL value above two will work or if u inserted some spaces give condition according to that.