HOW TO FIND Similar NAMES IN SQL TABLE

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)

0

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.

0

JAYRAM12y ago

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

0

hi,

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

0

Use Sql like-wise operator.

ex- where Name="%shashi%"

0