How do I search a specific data in SQL?

How do I write a SQL search query?

how to write a search query in SQL1IF the user enters ID = 123, then all the rows with ID = 123 should be fetched irrespective of name and city.2IF 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.how to write a search query in SQL - Stack Overflow

Is there a search function in SQL?

SQL Server CHARINDEX() Function The CHARINDEX() function searches for a substring in a string, and returns the position. If the substring is not found, this function returns 0. Note: This function performs a case-insensitive search.

How do I find a specific word in a database?

"Phrase searching" To search for a phrase, use double quotation marks around the words. This tells the database to search for occurrences of this specific group of words in exactly this order.