• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I FOUND A WAY TO DO IT!! Now how to edit Custom Fields?
#7
(12-19-2019, 03:23 AM)Zubersoft Wrote: 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


that worked perfectly.
I was able to access my Tablets using ANDROID FILE TRANSFER.

I've never done any SQL before so this was a first.  But I got all my tablets synced.
12 tablets (Insignia, ONN, Dragon Touch). Ranging from Android 5 to 9.
Reply


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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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