How to understand the role of mixmacth function in the where part of the Load statement

[cindy_user]

Hi all,

How to understand the role of macth function in the where part of the Load statement?

 see in the document the explanation of mixmatch is as follows：

Example Result

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

If I have a field M with values including'Jan','Feb','Mar', then I write where mixmatch( M,'Jan','Feb') in the load statement,Is there only data of'Jan' and'Feb left in the loaded data?

I don't understand why this function is equivalent to IN in SQL.Isn't it returning a number?

I am very confused now, can anyone explain the usage of the function?

will be grateful for your help.

[jwjackso · Accepted solution]

Henric's explanation.  Even though it is not necessary, I generally write the where clause like this:

Where Mixmatch(M,'Jan','Feb') > 0;

I find it less confusing.