How to include many "sub"-queries in a SQL statement to generate file paths for images?
- by Zachary
Greetings,
I have three fields in legacy MySQL database/application.
image_type
image_of_bush
image_prefix
I need to extract the data into a full image file path, into a .CSV file, where each combination (mentioned below) is a column. Can it all be done in SQL? Or can you recommend a better way? Currently using PHP to display the combinations…