select name from table where name like code example Example: select * from table where name like SELECT * FROM table_name WHERE column_name LIKE '%or%';