WHERE (first_name LIKE 'A%') OR (last_name LIKE 'K%') Query Example #5 SELECT stuent_id, First_name, Marks FROM customer Query Example #4 SELECT stuent_id, First_name, Marks FROM customer (this will fetch records of the student whose first_name ends with ‘t’ like Rohan, Raman, etc.

Query Example #3 SELECT stuent_id, First_name, Marks FROM customer (this will fetch records of a student whose first_name’s 2 nd character is ‘a’ like A adit, R aghav, etc.) Query Example #2 SELECT stuent_id, First_name, Marks FROM customer (this will fetch records of students whose last_name’s 2 nd character from last is ‘a’ ) We will write some queries and see how it will fetch the record.

(this will fetch records of student whose first_name’s 2 nd character from last is ‘a’ like Sohan ) Examples to Implement LIKE in MySQL (this will fetch records of a student whose first_name’s 2 nd character is ‘a’ like Aadit, Raghav, etc.)Įxample 5: SELECT stuent_id, First_name, Marks FROM student )Įxample 4: SELECT stuent_id, First_name, Marks FROM student (this will fetch records of a student whose first_name ends with ‘n’ like Rohan, Raman, etc. (this will fetch records of a student with an ‘a’ character in their first_name, like Sohan, Sakti, etc.)Įxample 3: SELECT stuent_id, First_name, Marks FROM student (here, it will fetch all records of the student whose first name starts with ‘A’, like Aseem, Abhishek, etc.)Įxample 2: SELECT stuent_id, First_name, Marks FROM student If we want to fetch records based on their names, then the LIKE operator will come into play.Įxample 1: SELECT stuent_id, First_name, Marks FROM student Let’s consider we have a student table containing the following attributes,

(here we search for the field column_name in the table table_name where column_name’s records start with A) How LIKE work in MySQL? Underscore (_) matches only a single character in the database.īasic syntax: SELECT column_name FROM table_name.Percentage (%) matches strings of zero or more characters in the database.MySQL provides two kinds of special characters for constructing our conditions to apply to strings.

Mysql like with underscore