• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I FOUND A WAY TO DO IT!! Now how to edit Custom Fields?
#6
Running SQL queries on the database is the way to go for something like this. I just tested the following and it works:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

This will strip everything after "(" in the Title. It will only impact titles that have a "(" in them. So execute the first query:

Update Songs Set Custom = Title

then execute:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

and I think you'll get exactly what you are looking for.

Mike
Reply


Messages In This Thread
RE: I FOUND A WAY TO DO IT!! Now how to edit Custom Fields? - by Zubersoft - 12-19-2019, 03:23 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2022 MyBB Group.