是否有更改来简化此数据库查询(每个请求必须运行多次),可能使用IN子句或其他内容?
SELECT `id`
FROM `tablename`
WHERE `columnname1` = "longer-value" OR
`columnname2` = "longer-value" OR
`columnname3` = "longer-value" OR
`columnname4` = "longer-value" OR
`columnname5` = "longer-value" OR
`columnname6` = "longer-value" OR
`columnname7` = "longer-value" OR
`columnname8` = "longer-value" OR
`columnname9` = "longer-value" OR
`columnname10` = "longer-value"
请注意,此查询在10个不同的列中检查该值。
我以前确实做过。。。
WHERE "longer-value" IN (`rowname1`, `rowname2`, ... , `rownameN`)