3 Replies Latest reply: Dec 17, 2015 4:57 AM by yeshu harsha RSS

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

      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