检查数据库行中是否匹配3个或更多匹配项 [英] Check if match 3 or more match in DB row

问题描述

我需要帮助来找出如何检查一行中是否已存在3列或更多列并获得正确/错误结果.

I need help to find out, how I can check if 3 or more columns already exists in a row and get a true/false result.

我的桌子的例子:

ID | NAME | REF | DOORS | ITEMS
1 | MASTER | 4 | 3 | 2
2 | MASTER | 2 | 3 | 4

示例1:

strName = "MASTER"
strRef 4
strDoors = 3
strItems = 1

在上面看到我的字符串，在这里您可以看到 NAME，REF，DOORS 与我的数据库(3个匹配项)中的行中的值相同，因此应返回 TRUE结果.

See my strings above, here you can see NAME,REF,DOORS is the same values in a row in my database(3 match), so this should return af TRUE result.

示例2:

strName = "MASTER"
strRef 1
strDoors = 1
strItems = 1

在此示例中，是否是 ONLY NAME 连续相同，但其他名称不同，并且应返回 FALSE结果.

In this Example, is it ONLY NAME what is the same in a row, but the others are different, and it should return af FALSE result.

有人可以给我一个关于SQL字符串或脚本的想法，如何解决这个问题吗?希望这是有道理的:)

Can anybody give me a idea to a SQL string or script, to how i can resolve this? Hope it's make any sense :)

推荐答案

我认为这些sql对您有帮助.请检查一下.

I think these sql will helpful to you. Please check it.

示例1 :SQL返回TRUE.

Example 1 SQL returns TRUE.

  Example 1:- SELECT CASE WHEN  NAME = "MASTER" AND Ref = 4 
               AND strDoors = 3 AND  Items = 1 THEN 'TRUE ' 
               ELSE 'FALSE' END FROM mytable

示例2 ，SQL返回FALSE.

Example 2 SQL returns FALSE.

Example 2:- SELECT CASE WHEN  NAME = "MASTER" AND Ref = 1 
            AND strDoors = 1 AND  Items = 1 THEN 'TRUE ' 
            ELSE 'FALSE' END FROM mytable

谢谢.

这篇关于检查数据库行中是否匹配3个或更多匹配项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！