Member Avatar for sachin.quadros

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

  • 2 Contributors
  • 3 Replies
  • 104 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by rajarajan2017
Member Avatar for rajarajan2017

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

Member Avatar for sachin.quadros

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.