select tables with name like sql code example

Example: select * from table where name like

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