I have this sample DB table:
id type c_owner_id c_linked_id
1 parent 1 2
2 parent 1 3
3 related 2 3
My script is provided a c_id
. I SELECT out all rows where this c_id
is the c_owner_id
OR c_linked_id
.
What I would like is to have in the same query an additional SELECT if the c_linked_id
equals the provided c_id
AND type
equals 'parent' that would select the rows that have a relationship with the same parent.
Pseudo SQL would be:
SELECT * FROM
table_name AS orig
WHERE
orig.c_owner_id = $c_id
OR orig.c_linked_id = $c_id
IF
orig.type = 'parent' AND orig.c_linked_id = $c_id
THEN
(
SELECT * FROM
table_name AS sub
WHERE
sub.type = 'parent'
AND sub.c_owner_id = orig.c_owner_id
)
Is this type of "IF THEN SELECT" statement possible in MySQL?