Can a variable be used in sqlite pattern match in python3

I have a very simple database that holds basic weather data, ie, date (yyyy-mm-dd), max-temp, min-temp and rainfall (date, max, min, rain). I'd like to be able to use input method to assign yyyy-mm to a variable that can be used in SELECT * FROM data WHERE date 'yyyy-mm%'. Is this possible? If so, could you point me to a good tutorial, please.