SQL multi-condition query join in Condition Method

The front-end can select multiple different conditions under the same field, which involves the problem of SQL statement concatenation.

The following is a method for processing query conditions using regular expressions. It is the simplest method I have seen and I will share it with you.

Using System. Text;

Using System. Text. RegularExpressions;

String strwhere = ,";

Strwhere = string. Format ("select

* From test where strwhere in ({0}) ", Regex. replace (strwhere. trimEnd (','), @ "[^,] +", "'$0 '"));

Note: Here strwhere. TrimEnd (',') is used to remove the comma after 1111.