SQL Like

SQL Like

The SQL LIKE is used to return lines if the operand matches a pattern in a select query.

Like syntax

SELECT * FROM table_name WHERE column_name LIKE pattern;

Like example

Coder books table

ID Title Price Description
1 Learn SQL 20 Learn SQL language
2 Learn MySQL 22 Learn MySQL language
3 HTML book 17 Learn HTML
4 Learn PHP 20 Introduction to PHP
5 Learn PHP 20 PHP course
select * from coder_books where title LIKE '%PHP%';

Result

ID Title Price Description
4 Learn PHP 20 Introduction to PHP
5 Learn PHP 20 PHP course
select * from coder_books where description LIKE 'Learn%';

Result

ID Title Price Description
1 Learn SQL 20 Learn SQL language
2 Learn MySQL 22 Learn MySQL language
3 HTML book 17 Learn HTML
select * from coder_books where price LIKE '17';

Result

ID Title Price Description
3 HTML book 17 Learn HTML