HOW TO FIND Similar NAMES IN SQL TABLE

Question

I have table likt this...... Name shashi raju karthik pranay shashidhar vamshi vamshikri g.pranay select only similar names ............. i want output like this............. shashi shashidhar vamshi vamshikri pranay g.pranay

Abhineet Srivastava · Answer

Use Sql like-wise operator. ex- where Name=%shashi%

Goutham Ks · Answer

Pls have a look at this..it worked for me select * from nameslist output: name ------------------------------ abcdef sashi jack jill jillman he krish krishh3 shashidhar shashi (10 row(s) affected) select *from nameslist where name like '%shi%' output: name ------------------------------ sashi shashidhar shashi (3 row(s) affected)

Jignesh Trivedi · Answer

hi that is fine In your above question you represent only the output what is your input here? I am still confused in your question.

JAYRAM · Answer

in my sql table have more then 2000 name ...........

Jignesh Trivedi · Answer

hi what do you mean similar name? can you please explain more?