Table1
IDColumn11[1-100]2Amrut got 11% hike3Am's4[1-100]5[amrut]6[1-100-200]7[amrut] is good boy
I have a table as above.
Case 1: If i search column1="[1-100]"
expected: I should get only 1st and 4th row
Case 2: if i search column1st contains "[1-100]"
expected: I should get only 1st and 4th row
Case 3: If i search column1 begins with "[1-100]"
expected: I should get only 1st and 4th row
Case 4: If I search column1 begins contains "[1-10"
expected: I should get 1st,4th & 6th row.
Case 5: If I search column1 for "[amrut]"
expected: 5th row for equalsto
5th & 7th for contains and begins with operater