- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- Related Articles
- Add a column count in a MySQL query on the basis of last name records?
- Display records where first and last name begins with the same letter in MySQL
- 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?
- 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
- Fetching records from a table with NULL and other values on the basis of conditions in MySQL
- How to display first day and last day of the month from date records in MySQL?
- Select records from a table on the basis of keywords in MySQL
- MySQL query to select everything to left of last space in a column with name records
- Select and filter the records on month basis in a MySQL table?
- How to compare the first date and the last date from a MySQL column with date records?
- MySQL query to display records on the basis of conditions IS NULL OR !=1;?

Advertisements