SELECT * FROM table_name WHERE col_name = my_value; SELECT * FROM table_name WHERE col_name LIKE '%my_value%';