Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'???

[#1]

Hi,

I am trying to understand the following functions

1. Like

2. match

3. Mixmatch

4.Wildmatch

Edit Script:

[Table1]:

Load *  INLINE [

ID, Name, Dept

1,AAA,D1

2,BBB,D2

3,CCC,D3

4,BBB,D4

]

Assume now i have loaded this table "Table1"

I would require to create another table from 'table1' where the field "name"  has the letter 'b' or letter 'c'

## This works##

[Like_Example]:

Load

ID as newID,

Name as newname,

Dept as newdept

Resident [Table1]

where

Name like ('*a*')

## THIS DOESNT WORKS##

[Like_Example]:

Load

ID as newID,

Name as newname,

Dept as newdept

Resident [Table1]

where

Name like ('*a*', '*c*')

If i need to search for both 'a' and 'c', then what is that i should be using?

How to use Match, Mixmatch and Wildmatch with the following example instead of like.

Can someone please help me in understanding this.

Thanks

Sarathi

[Anonymous]

follow http://qlikshare.com/

all the function were demostrated with small examples

[IAMDV]

Thanks Raj.

Cheers,

DV

www.QlikShare.com

[#4]

Dear sarathi,

in simple terms:

Match is use insted of writing multiple where conditions or if conditions

for example:

where product='a' and product ='b' and product='c';

by using match we can write like

match(product,a,b,c)

in the same way

wild match is to use match with wild characters %

and mix match is case insensitive

and like is instead of multiple where its same as match.