How to ignore cases in SQLite within Python script?

Question

I am trying to get User_ID from database with the help of username without considering the case of the username.

I want something like this:

query="Select User_ID from Users where username LIKE '%?%'"
cursor.execute(query,(username,))

rows = cursor.fetchall()

For example:

Username - Elon_Musk

User_ID - 101

In my code, the username gets converted to elon_musk. If I get data using this (elon_musk) username, I get empty result.

How can I solve this? Thank You.