I have a form textarea field with the name "Key Notes", this accidentally has a double space. I only noticed it as it doesn't work when you put {Key Notes:caption}: {Key Notes:value} in a User or Admin email. Every other field is fine. So I changed the field name to single space "Key Notes", but the existing records don't show up in resent emails or in the directory details.

I expect I have to edit my database with my phpmyadmin. I could probably fumble my way into it, but if someone knows how to search and change all existing "Key Notes" (double space) to "Key Notes" (single space) and could tell me that would be great!

Suggestions? As you might expect "Key Notes" is an important part of the emails sent out.

I had a friend of mine give me a quick hand. He changed the double space to single space for me in the submissions table I believe.

I knew what had to be done, just didn't know how to get it done. I didn't screen shot the command he used, sorry I couldn't be helpful to someone else.