MariaDB 11.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

11.4.4-MariaDB-deb12

CREATE TABLE myTable (
  id INT NOT NULL auto_increment PRIMARY KEY,
  myCol enum('M', 'B') );

INSERT INTO myTable (myCol) VALUES ('M'), ('B');

Records: 2  Duplicates: 0  Warnings: 0

SELECT * FROM myTable WHERE myCol='B';

id
myCol

2
B

SELECT * FROM myTable WHERE myCol=2;

id
myCol

2
B

SELECT id, myCol+0 FROM myTable;

id
myCol+0

1
1

2
2