How to treat Evernote like a database

[BDon 0]

If I want to track my drumming progress over many different songs. I figure I would make each song a different note, but I need identical fields with different values across each note. For example... "length of song (min:sec)", "personal rating (1-5)", "accuracy percent (0-100%)", and "beats per minute (1 - 200 bpm)". How do I filter through all my notes for songs that match certain search criteria? Show me all the songs where BPM is < 150; Ratings >= 4/5; and haven't been updated in the last month?

If later I want to add another field, how can I do that for all the notes without having to manually adding it in a tedious and error-prone way?

[BDon 0]

Just now, BDon said:

If I want to track my drumming progress over many different songs. I figure I would make each song a different note, but I need identical fields with different values across each note. For example... "length of song (min:sec)", "personal rating (1-5)", "accuracy percent (0-100%)", and "beats per minute (1 - 200 bpm)". How do I filter through all my notes for songs that match certain search criteria? Show me all the songs where BPM is < 150; Ratings >= 4/5; and haven't been updated in the last month?

If later I want to add another field, how can I do that for all the notes without having to manually adding it in a tedious and error-prone way?

Worse yet, maybe some fields wouldn't be common across all notes. For example, maybe I want to break down my progress by section INTRO (0-100%), CHORUS (0-100%), VERSE (0-100%), etc. Not all songs have that same format, so I'd need 'searchable flexibility'.

[Joe Pairman 19]

Evernote isn’t designed this way. It’s geared around “notes like paper” with manual formats, as well as tagging and search, but not the kinds of standardized properties you’re describing. You could create a note template, containing a table with predefined rows or columns for the various criteria. But that’s not data in a structured sense, still just body text. 
 

A better tool for what you’re describing is Notion. You can add properties to a whole “database” of notes, getting an overview in a filterable table, but still being able to open any individual note and add all sorts of body content too. 

[gazumped 11,664]

A still better tool would be an actual database or a spreadsheet,  not a note-tool.  Try AIrtable - it's both database and spreadsheet,  and you can start adding records right off the bat.  If you find you need extra fields or different views you can change the layout at any time.