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
Aman rathore 5 days 1 Answer 12 views Member 1

Answer ( 1 )

  1. Ans
    SELECT *
    FROM
    employees
    WHERE
    First_name LIKE(‘Mar%’);

Leave an answer

Browse
Browse