Need to populate autocomplete with records on the basis of first and last name of schools in MySQL?

To populate autocomplete, use the LIKE clause in MySQL. Let us first create a table −

mysql> create table DemoTable
(
   SchoolName varchar(100)
);
Query OK, 0 rows affected (0.56 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable values('Horce Greeley');
Query OK, 1 row affected (0.20 sec)
mysql> insert into DemoTable values('Conestoga Senior');
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable values('Adlai E.Stevenson');
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable values('Thomas Jefferson');
Query OK, 1 row affected (0.07 sec)

Display all records from the table using select statement :

mysql> select *from DemoTable;

This will produce the following output −

+-------------------+
| SchoolName        |
+-------------------+
| Horce Greeley     |
| Conestoga Senior  |
| Adlai E.Stevenson |
| Thomas Jefferson  |
+-------------------+
4 rows in set (0.00 sec)

Following is the query to populate autocomplete with records −

mysql> select *from DemoTable where SchoolName LIKE '%Con%' and SchoolName LIKE '%Sen%';

This will produce the following output −

+------------------+
| SchoolName       |
+------------------+
| Conestoga Senior |
+------------------+
1 row in set (0.00 sec)

AmitDiwan

Published on 09-Oct-2019 10:29:18

• Related Questions & Answers
• Add a column count in a MySQL query on the basis of last name records?
• How to display the day name on the basis of Date of Birth records in MySQL?
• Search records on the basis of date in MySQL?
• Display records where first and last name begins with the same letter in MySQL
• Fetch records on the basis of LastName using MySQL IN()
• Select items based on value first, then order on the basis of date for rest of the records in MySQL
• Display records on the basis of key-value pairs in MySQL
• MySQL query to ORDER BY records on the basis of modulus result
• Select records from a table on the basis of keywords in MySQL
• Validate the first name and last name with Java Regular Expressions
• Fetching records from a table with NULL and other values on the basis of conditions in MySQL
• Get left part of the string on the basis of last occurrence of delimiter in MySQL?
• MySQL query to select three highest values and sort alphabetically on the basis of corresponding column with name
• Select and filter the records on month basis in a MySQL table?
• MySQL query to display records on the basis of conditions IS NULL OR !=1;?