SQL LIKE

SQL LIKE keyword used in WHERE clause to retrieve the results based on a Pattern.

Syntax:

SELECT Columns
FROM Tables
WHERE column_name LIKE {PATTERN}

Some Samples:

SELECT Column1
FROM table_name
WHERE column_name LIKE ‘%TEN%’

24 views

Return to top