sql - How to know how many OR conditions are satisfied? -
How can I know how many conditions are satisfied in my results [TITLE ] From [M_TIPS] to [TITLE] as '% VALUE%' or '% SQL%' like [TITLE]; How will it know that only 1 or the condition of the result has been satisfied and both of the results have satisfied the conditions. The number of conditions is not stable, it can increase. Can anyone help? Add to result: select [TITLE] case [ TITLE] is like '% VALUE%' when the '% sql%' as the last [TITLE] as 1 and 0 as the CONTAINS_VALUE case when the CONTAINS_SQL FROM as [M_TIPS] as the 1 and 0 '[VALUE] ] 'Like' [VALUE] 'or' [TITLE] 'like'% SQL% ';