Community Contributions > SQL Workbench

Deleting Notes from multiple clubbers

(1/1)

James:
I make a lot of notes in the "Notes" section of my clubbers file.  I set up my New Club year but the notes from last year are still there.  Is there a quick method to delete all the old notes or do I have to edit each clubber individually?

Thanks!

James

Rick Leffler:
If you really want to wipe out all of your notes, you can use the SQL workbench (Admin > Database Utilities) to do this.  Use the following statement:

                              update Person set Notes = null

if you only want to clear the notes on Clubbers but not Leaders you could use:

                             update Person set Notes = null where Member_Type = 'Clubber'

James:
Awesome!  Thanks! 

Navigation

[0] Message Index