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
What I would like is to have in the same query an additional SELECT if the
c_linked_id equals the provided
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?