query for pattern in SQL？

Hi, LIKE operator is used for pattern matching, and it can be used as -.

% – Matches zero or more characters.
_(Underscore) – Matching exactly one character.

Example -.

Select * from Student where studentname like 'a%'
Select * from Student where studentname like 'ami_'

mysql> select * from books where name like "x%";
+------+--------+------+------+
| name | author | jb   | id   |
+------+--------+------+------+
| xig  | sdds   | NULL | NULL |
+------+--------+------+------+
1 row in set (0.00 sec)