如何返回共享值的列的名称？

Question

我正在尝试返回共享一个值的列的名称。我想我可以对数据库进行查询，然后提取出名字。

例如，当我的共享值为Tarantino时，我希望返回Director和Actors列，因为他既是演员又是导演。

String x = "Tarantino";

String q =
        "SELECT Actors, Director, Genre, Country, Released, WHERE Actors LIKE '%"+x+"%' " +
        "AND WHERE Director LIKE  '%"+x+"%' " +
        "AND WHERE Genre LIKE  '%"+x+"%' " +
        "AND WHERE Country LIKE  '%"+x+"%' " +
        "AND WHERE Released LIKE  '%"+x+"%' " ;

然后，我可以遍历游标并获得列名Director和Actors

Answer 1

要在一列中查找匹配项，请尝试执行以下操作：

select exists (select * from actors where director like '%"+x+"%');

要将这四种情况放在一起，您可以尝试：

select q1, q2, q3, q4 
from
  (select exists (...) as q1)
  join
  (select exists (...) as q2)
  join
  (select exists (...) as q3)
  join
  (select exists (...) as q4)

已被取代：

您是否尝试过：

    "SELECT Actors, Director, Genre, Country, Released, WHERE Actors LIKE '%"+x+"%' " +
    "AND Director LIKE  '%"+x+"%' " +
    "AND Genre LIKE  '%"+x+"%' " +
    "AND Country LIKE  '%"+x+"%' " +
    "AND Released LIKE  '%"+x+"%' " ;

请注意，SELECT的工作方式是返回所有列。查询应返回与所有四个条件都匹配的行。然而，我认为你正在尝试做一些不同的事情。到底什么是我不清楚的。