Select case result of a select statement (check multiple rows for condition)

Question

I have a simple query here, basically I want to check the rows for a combination of parameters to have each person logged on a project only once. I want to check for the id/info combo and return either the id or a 0 for new entry. The query here returns nil, but I'd like to return 0 if no results found. I can check all rows using case or IF statements, but I just can't get the query right to select based on the results from all rows. Thanks!

SELECT id FROM project_team WHERE name = ? AND project_id = ?

give some sample data, expected output and what is your current query returning ? — Madhur Bhaiya, Sep 10 '18 at 17:02
@vhu thanks, just what I needed.. I was trying If Not Null, Ifs .. couldn't find that one! — nick, Sep 10 '18 at 17:04

score 2 · Answer 1 · edited Sep 10 '18 at 17:07

2

You could use the IFNULL() function:

SELECT IFNULL(id, '0') FROM project_team WHERE name = ? AND project_id = ?

Or possibly:

SELECT(IFNULL((SELECT id FROM project_team WHERE name = ? AND project_id = ?), 0))

edited Sep 10 '18 at 17:07

Madhur Bhaiya

28,155
10
49
57

answered Sep 10 '18 at 17:04

dustytrash

1,568
1
10
17

iffnul is not mysql – ScaisEdge Sep 10 '18 at 17:05

score 2 · Answer 2 · answered Sep 10 '18 at 17:04

2

Use IFNULL function:

SELECT IFNULL(SELECT id 
              FROM project_team 
              WHERE name = ? 
                AND project_id = ?, 0)

answered Sep 10 '18 at 17:04

Madhur Bhaiya

28,155
10
49
57

Select case result of a select statement (check multiple rows for condition)

2 Answers2