How to regex in a MySQL query

March 13, 2023 by Tarik

I think you can use REGEXP instead of LIKE

SELECT trecord FROM `tbl` WHERE (trecord REGEXP '^ALA[0-9]')