I have the database as below picture shown:
I want to get the numbers under "ID" colm with "0" value in "is_parent".
How to do that with a sql query?
I want the numbers going to be link this:
1792,2304,1793,1794,2308.. etc..
Tried my best, with failed attempt, hopefully someone can help me with the correct query.
Thank you,
regards.
Answer
Try this, it is simple
SELECT id FROM `table_name` WHERE is_parent= 0
No comments:
Post a Comment