php - How to get the numbers of a column in phpmyadmin?

Friday, May 3, 2019

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

Blog