那么SELECT * FROM INFBOARD WHERE (TOPIC = '%N%') AND (CONTEXT = 'a') OR (TOPIC = '%N%') AND (1 = 1) 简化以后的语句是什么?是 SELECT * FROM dbo.INFBOARD WHERE (TOPIC = '%N%')吗?
在这个sql语句中:SELECT * FROM dbo.INFBOARD WHERE (TOPIC = '%N%') AND (CONTEXT = 'a' OR 1=1) 我要得到的结果是先进行(CONTEXT = 'a' OR 1=1)判断,结果为1=1即全部集合,然后再和(TOPIC = '%N%')进行AND操作,结果是得到TOPIC = '%N%'即所有符合这个条件的记录? 如果我这么写从根本上是错误的,那么请各位大虾教教我!谢谢!
FROM INFBOARD
WHERE (TOPIC = '%N%') AND (CONTEXT = 'a') OR
(TOPIC = '%N%') AND (1 = 1)
简化以后的语句是什么?是
SELECT * FROM dbo.INFBOARD WHERE (TOPIC = '%N%')吗?
我要得到的结果是先进行(CONTEXT = 'a' OR 1=1)判断,结果为1=1即全部集合,然后再和(TOPIC = '%N%')进行AND操作,结果是得到TOPIC = '%N%'即所有符合这个条件的记录?
如果我这么写从根本上是错误的,那么请各位大虾教教我!谢谢!