asked on How to change Search query that contain particular word n Sql
Hi Experts ,
We need to search in database with the record contains particular Data in it e.g. name column could search for all words that contains 'jon' in it. Is this correct query
my code
We need to search in database with the record contains particular Data in it e.g. name column could search for all words that contains 'jon' in it. Is this correct query
my code
SELECT Name FROM Person WHERE Name LIKE '%Jon%'
ASP.NETMicrosoft SQL ServerDatabases
Last Comment
karthik80c
ASKER
Hi Lokesh ,
What if i need to go for exact match
What if i need to go for exact match
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank You Experts For Your Great Effort
yes it is correct.
It will look for the word where it contains "Jon" in the Name column.