USING WILDCARDS IN MYSQL
Question
Q5. Working with the “employees” table, select the data about all individuals, whose first name starts with “Mar”; specify that the name can be succeeded by any sequence of characters.
| Emp_id | First_name | Last_name | Sex | Hire_date |
| 1 | Mark | Johnson | M | 2021-06-27 |
| 2 | Marcus | stoniss | M | 2020-05-04 |
| S3 | Babita | Iyer | F | 2021-06-18 |
| 4 | Jethalal | Gada | M | 2019-07-16 |
| 5 | Neymar | Chapel | M | 2019-08-09 |
| 6 | Atmaram | Bhide | M | 2018-09-10 |
| 7 | Daya | Gada | F | 2020-06-07 |
in progress
0
SQL
55 years
1 Answer
815 views
Member 1
Answer ( 1 )
Ans
SELECT *
FROM
employees
WHERE
First_name LIKE(‘Mar%’);