mysql where, like %

SELECT * 
FROM TABLE
WHERE COLUMN LIKE 'string%'
LIMIT 50;

-- output

mysql> select * from dept_emp
    -> where from_date like '1992%'
    -> limit 5;
+--------+---------+------------+------------+
| emp_no | dept_no | from_date  | to_date    |
+--------+---------+------------+------------+
|  10012 | d005    | 1992-12-18 | 9999-01-01 |
|  10015 | d008    | 1992-09-19 | 1993-08-22 |
|  10018 | d004    | 1992-07-29 | 9999-01-01 |
|  10036 | d003    | 1992-04-28 | 9999-01-01 |
|  10046 | d008    | 1992-06-20 | 9999-01-01 |
+--------+---------+------------+------------+