SQL query to find all specific value in all columns based on row id.

Question

[lippithakkar]

My data looks like this

My question: is there any SQL query which allows us to determine specific column values with respect to the row id? Here I want to know the values of all the columns having AA in row1. I want an output mentioning row id and all columns having AA value.

Any help is highly appreciated.

Best,

[Pierre Lindenbaum]

show us the schema for your database