'Add New Result Below The Result of Mysql Select

This my table

Table View

This what I want

enter image description here

Its gonna be easy if we use php, but I want to know, is it possible with query?



Solution 1:[1]

Select * from table where kode in (Select group_concat(id) as ids from table where kode=0) Order by kode asc

you can try with this type of query

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Priyanka Pareek