mysql - 如何在MySQL中使用“值”作为列名？

如何在MySql的select语句中使用value？它是保留关键字。代码：SELECT unit.cleunit FROM ( ( metas metas INNER JOIN metas_unit metas_unit ON (metas.clemetaunit = metas_unit.clemetaunit)) INNER JOIN metas_values metas_values ON (metas_values.clemetaunit = metas.clemetaunit) AND (metas_unit.clemetaunit_values = metas_values.clemetaunit_values)) INNER JOIN unit unit ON (unit.cleunit = metas_unit.cleunit)式中（单位：etatunit0）和（unit.isdeleteunit=0）和（（metas_unit.value类似于“%NOM%”）或（metas_values.metavalues_name，如'%%NOM%'） 最佳答案 请尝试以下操作：SELECT * FROM MyTable WHERE `Value` = 1有关更多信息，请参见reserved单词和identifiers。更新：sql查询：SELECT unit.cleunitFROM metasINNER JOIN metas_unit ON metas.clemetaunit = metas_unit.clemetaunitINNER JOIN metas_values ON metas_values.clemetaunit = metas.clemetaunit AND metas_unit.clemetaunit_values = metas_values.clemetaunit_valuesINNER JOIN unit ON unit.cleunit = metas_unit.cleunitWHERE unit.etatunit <> 0 AND unit.isdeleteunit = 0 AND (metas_unit.`value` LIKE '%%NOM%%' OR metas_values.metavalues_name LIKE '%%NOM%%')关于mysql - 如何在MySQL中使用“值”作为列名？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/10221555/