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