Saturday, 16 July 2016

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




I have the database as below picture shown:




enter image description here



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

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...