Which command is used to match any string of at least 3 char in SQL?

Question

Can anyone tell me which command is used to match any string of at least 3 char in SQL?

Answer 1

We can use LIKE operator to search for any specific pattern in a column. Here is the query to match any string of at least 3 characters in length:

SELECT column_name

FROM table_name

WHERE column_name

LIKE ‘_%_%_’

I recommend this SQL Training course by Intellpaat to learn more about LIKE operator and wildcard characters like ‘%’, ’-‘, ‘^’, ‘[]’.