mysql 从列名等于的表中选择

Question

我有一个简单的表格

amps | 120-240 | 120-208 | 277-480__________________________________10   |  $99.00  | $149.00 | $344.0020   | $199.00 | $298.00 | $688

I want a query something like this but I can't get it to work ...

select * from `table` where amps like '10' and column_name like '120-208';

或

select * from `table` where amps like '20' and column_name like '277-480';

请帮忙!也许我忽略了一种更简单的设置方法？

谢谢!

Answer 1

就这样？

SELECT `120-208` FROM table WHERE amps = '10'