---
title: "How and when to use LIKE statement?"  
description: "How and when to use LIKE statement?"  
author: "Anonymous User"  
published: 2011-02-01  
updated: 2020-09-16  
canonical: https://www.mindstick.com/interview/349/how-and-when-to-use-like-statement  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How and when to use LIKE statement?

we use "like" in query as\
\
SELECT column_name(s)\
FROM table_name\
WHERE column_name LIKE pattern\
\
and used to search for a specified pattern in a column.\

## Answers

### Answer by Anonymous User

we use "like" in query as\
\
SELECT column_name(s)\
FROM table_name\
WHERE column_name LIKE pattern\
\
and used to search for a specified pattern in a column.\


---

Original Source: https://www.mindstick.com/interview/349/how-and-when-to-use-like-statement

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.