mysql - SQL 查询的 WHERE 子句中的 CASE 语句

Question

我想编写一个查询，在运行时根据条件构造 WHERE 子句。这是我想要做的。

SELECT name from data_table WHERE 
CASE
WHEN input_data = location THEN <where condition should be based on location>
WHEN input_data = college  THEN <where condition should be based on college name>

我该怎么做呢？可能吗？

Answer 1

SELECT name from data_table
WHERE (input_data = location AND condition based on location)
   OR (input_data = college  AND condition based on college name)