[SQL] 在SQL中使用正規表示式Regular Expression

UPDATE files SET type="image" WHERE origin_type REGEXP '^image'
SELECT  * FROM files WHERE origin_type REGEXP '^image'