We can get the column values in single row by , using GROUP_CONCAT() and CONCAT() methods. Check the below queries for reference.
select group_concat(concat('[',id,']')) AS ids from table_name;
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?