我想编写一个查询,根据条件在运行时构建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>
我该如何做到这一点?这是可能的吗?
demo
查看。 - M Khalid Junaid