Hi Friends,

I want to search a table with 25 columns using multiptle fields, i.e. Multiple column search

Please help me with the query, i have tried using AND but no luck

Field to search
1.Date
2.Name
3.Surname
4.Fathername
5.MotherName


Rgrds
Sachin

Member Avatar for rajarajan2017

SELECT Date,Name,Surname,Fathername,Mothername FROM details where Name='Raja' AND Fathername='Rajendren';

Thanks RajaRajan your code worked!

Member Avatar for rajarajan2017

Please Mark Solved, if it is solved!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.