How to refer to column 'BY' in query?
<p>In my Google spreadsheet, i'm using the query function to get data from one sheet onto another. The query looks something like this:</p>

<p><code>=QUERY('mySheet'!$A$1:100,"select F where "&amp;C$3&amp;"='myValue'")</code></p>

<p>This works fine until cell C3 has value "BY" (because the word "by" has significance in the query language). I've tried using single quotes, but then the query uses header "BY" instead of column BY and it returns an empty result.</p>

<p>Any ideas on how to work around this?  </p>