One more sql-question

Discuss using and your tips/tricks for CATraxx
Post Reply
Cally
Posts: 26
Joined: Wed Sep 16, 2015 6:25 am
Location: Germany

One more sql-question

Post by Cally » Tue Jan 09, 2018 8:20 pm

Hi everybody,

to begin the new year with new energy in catraxx I want to ask for help with a sql-statement.
If field title contains „Medley“ I want to write every entry in field “subtitle” into the field “notes” row by row (or separated by an * or something else). If field "notes" is not empty I want to save the current content at the end of this field in brackets.
Example

Before:
catraxx_subtitle_01.jpg
catraxx_subtitle_01.jpg (98.33 KiB) Viewed 202 times

This is the result I want to get automaticly by sql:
catraxx_subtitle_02.jpg
catraxx_subtitle_02.jpg (113.98 KiB) Viewed 202 times
Thanks for help and greets from germany
Martin

Cally
Posts: 26
Joined: Wed Sep 16, 2015 6:25 am
Location: Germany

Re: One more sql-question

Post by Cally » Tue Jan 16, 2018 6:41 am

Hello,

I've just updatet my sql-question with two screenshots.
Maybe that helps... ;)

Greets from germany
Martin

Post Reply