php SQL多个IN数组[重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

I am trying to execute the following query:

SELECT * FROM inbound WHERE direction = 'inbound' AND shortcode IN (60777) AND trigger IN (G6AAJ) ORDER BY daterecieved DESC LIMIT 1

But I get the error:

#1054 - Unknown column 'G6AAJ' in 'where clause'

I cannot figure out why, any with this help appreciated.

</div>

Answer 1

It's interpreting G6AAJ as a column name, try IN ('G6AAJ')