Bind the name of a parameter

In Doctrine, is it possible to bind the name of a parameter
(contrary to binding the value of a parameter)?

Why I need it

There is a table having 7 boolean columns, one for each day of the week: monday, tuesday, etc. (these correspond to the structure of the calendar entity defined by GTFS, https://gtfs.org/schedule/reference/#calendartxt).

Given a day of the week (say, monday), I want to get all rows, which are available on Mondays, i.e.:

$statement = $this
    ->getEntityManager()
    ->getConnection()
    ->prepare('
        SELECT id
        FROM calendar
        WHERE monday = 1
    ');

Generally, I want to be able to supply the name of a day in that query, which I can do simply by:

->prepare("
    SELECT id
    FROM calendar
    WHERE $dayName = 1
");

I wonder whether it's possible to use the parameter binding for the names of parameters, i.e. something like

$statement = $this
    ->getEntityManager()
    ->getConnection()
    ->prepare('
        SELECT id
        FROM calendar
        WHERE :dayName = 1
    ');

$statement->bindValue('dayName', $dayName);

which does not work, see below.

What I tried

#1

WHERE :dayName = 1

which translates to the following SQL query:

SELECT calendar.id
FROM calendar
WHERE 'monday' = 1

and, because that condition is never true, returns an empty set, [].

#2

WHERE `:dayName` = 1

SELECT calendar.id
FROM calendar
WHERE `'monday'` = 1

Column not found: 1054 Unknown column ''monday'' in 'where clause'

#3

WHERE ":dayName" = 1

# no query

Invalid parameter number: number of bound variables does not match number of tokens

This is of course not possible.

Within the statement, placeholders can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. The parameter markers should not be enclosed within quotes, even if you intend to bind them to string values. Parameter markers can be used only where expressions should appear, not for SQL keywords, identifiers, and so forth.

In short: you can use parameter markers for literals (string, numbers, ..) only

If you can't change your database design I would recommend using another SQL statement with a simple bit check:

prepare("select id, (monday + 
                     tuesday * 2 + 
                     wednesday * 4 + 
                     thursday * 8 + 
                     friday * 16 + 
                     saturday * 32 + sunday *64) as day
from calendar having (day) & (1 << :daynumber)")

Now you can simply check if a service is available on a specific weekday, by binding the daynumber (monday=0, tuesday=1, .. sunday=6).