Hi Friends, Today we will discuss on the full-text searching using MySQL. First of all, we need to create columns for text searching. So I have created 2 columns for searching, address1 and address2.
CREATE TABLE employeeAddress(
To search for employee addresses with ALL address1 and address2 in the data.
SELECT * from employeeAddress
WHERE MATCH (address1,address2) AGAINST (‘new delhi’);