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

select * from coder_books where title LIKE '%PHP%';

Result

select * from coder_books where description LIKE 'Learn%';

Result

select * from coder_books where price LIKE '17';

Result