Like Operator & Wildcards

 

Like operator and wildcards:

1.% -> 0 or more characters

2._ ->exactly one character representation

 

Syntax with Example:

       i.          Select name from smarks where name like ‘%a’; //end with a

      ii.          Select name from smarks where name like ‘%am’; //end with am

    iii.          Select name from smarks where name like ‘a%’; //start with a

    iv.          Select name from smarks where name like '%a%';//any position with a

      v.          Select name from smarks where name like '_a%'; //second position

    vi.          Select name from smarks where name like 'a__%'; //after a it checks atleast 3characters