How do I write a SQL search query?
how to write a search query in SQLIF the user enters ID = 123, then all the rows with ID = 123 should be fetched irrespective of name and city.IF the user enters ID = 123 and name = 'SAM', then all the rows with ID = 123 and name = 'SAM' should be fetched irrespective of the city...