SELECT * FROM TABLE WHERE name LIKE 'a_' code example

Example: select * from table where name like

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