like in select on column name code example

Example: select * from table where name like

SELECT * FROM table_name
WHERE column_name LIKE '%or%';