You wrote an extra%, and the syntax format of the LIKE statement is: select * from table name where the field name like corresponds to the value (substring). LIKE'Mc%' will search all strings starting with the letter Mc (such as McBadden).

2. Like "%inger" will search all strings ending in the letter inger (such as r inger and Stringer).

3. Like "%en%" will search all strings containing the letter en anywhere (such as Bennet, Green, McBadden).