retriving of data please help me.

Question

suppose this is my table

id name address
1 nazir57 gnt
2 suresh hyd
3 sasi priya tpt
4 sankar15 vzg

i want result like the following

id name address
2 suresh hyd
3 sasi priya tpt

how to write the querry for the result. how to write the where condition

please help me

Biswa Pujarini Mohapatra · Answer

Thanks for your reply. here is your code Select * from table where name not like '%[0-9]%'

Suresh Babu · Answer

dis is my id budati.suresh57@gmail.com send me rply as early as possible

Biswa Pujarini Mohapatra · Answer

Definitely give me your email id I will reply on that please mark it as answer

Suresh Babu · Answer

May I knw u r mail id plz

Suresh Babu · Answer

thanku its correct

Suresh Babu · Answer

thanks for replying i want to get the data dynamically am not mention any names or like operators suppose am having a table with 100 records in which 20 are name with numeric (suresh57) and remaining are normal text.. i want to retrive only text names only not with name with numeric names r u understand my question now thanku pls give me reply

Biswa Pujarini Mohapatra · Answer

Select * from table where name ='suresh' and name ='sasi priya' or do you want the result name start with S ?