How to get the numbers of a column in phpmyadmin?

Question

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.

Possible duplicate of [How to get data from database and echo on php page?](http://stackoverflow.com/questions/19489439/how-to-get-data-from-database-and-echo-on-php-page) — coderodour, May 19 '17 at 20:48
Can you please update your question and show us your best attempt at solving this problem yourself? — devlin carnate, May 19 '17 at 20:49

score 0 · Accepted Answer · answered May 19 '17 at 20:54

0

Try this, it is simple

SELECT id FROM `table_name` WHERE is_parent= 0

answered May 19 '17 at 20:54

Ramana V V K

Why the downvotes? This is a perfectly good answer, despite the poor question. – Callum Watkins May 20 '17 at 13:22

score 0 · Answer 2 · edited Jun 18 '17 at 03:23

0

well, if

SELECT id FROM `table_name` WHERE is_parent= 0

fails, you may try:

SELECT id FROM `table_name` WHERE is_parent IN (1792,2304,1793,1794,2308....)

or:

SELECT id FROM `table_name` WHERE is_parent != 0

edited Jun 18 '17 at 03:23

josliber

answered May 19 '17 at 22:33

f b

Your second two examples clearly do not work for the problem asked in the question. – Callum Watkins May 20 '17 at 13:20

2 Answers2