mysql column start with string code example

Example: mysql column start with string

SELECT col1, col2
FROM table_name
WHERE col_name LIKE CONCAT(value, '%')