Show unread posts since last visit Show new replies to your posts
Pages: [1]
*

gnoe

  • **
  • 20 posts
Sample SQL to export data more than 1 image
« on: March 22, 2024, 09:00:12 AM »
Hi support and community.

As title says, is there any sample SQL script to retrieve more than 1 image from my DB ?

The supplied sample takes only the first one.
Thanks.
Logged
Aristotle: We are what we repeatedly do. Excellence, then, is not an act, but a habit.
*

MB Themes

Re: Sample SQL to export data more than 1 image
« Reply #1 on: March 23, 2024, 12:20:37 PM »
Easiest way is to ise subquery using function like listagg/stringagg, not sure what is equivalent in mysql
Logged
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots
Pages: [1]