IT Nursery
I am doing SELECT GROUP_CONCAT(categories SEPARATOR ' ') FROM table. Sample data below: categories ---------- test1 test2 test3 test4 test1 test3 test1 test3 ...
-
May 24, 2022
- 0 Comments
I’m using GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of ...
-
May 16, 2022
- 0 Comments
Using MySQL, I can do something like: SELECT hobbies FROM peoples_hobbies WHERE person_id = 5; My Output: shopping fishing coding but instead I ...
-
April 13, 2022
- 0 Comments
Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single ...
-
April 10, 2022
- 0 Comments