Beispiel #1
0
        public void TestConditionWhereFindInSetString()
        {
            // Query Principal
            var sqlRaw = "select * from test";
            var nsql   = new NSQLQuery(sqlRaw);

            nsql.WhereFindInSet("coluna1", "1,2,3,4,5");


            var expected = "select * from test WHERE FIND_IN_SET(coluna1,'1,2,3,4,5')";

            Assert.AreEqual(expected, nsql.ToSql(), true);
        }