RegEx with update query my sql i need to use a mysql  update query with regex so my example is 

update table_name set coulmn_name = replace(coulmn_name, 'regex', '');


i will explain a specified thing i need to do. my column is contained some text &amp; some html tags i need to delete all img tags from this coulmn  what can i do to achieve this ?

this is my ReGex

/&lt;/?(?i:img)(.|\n)*?&gt;/g


but i don't know how to make this
any help please
MySQL doesn't support it natively, but this is possible if you install the user-defined functions from the lib_mysqludf_preg library.

You should be able to then do something like this:

UPDATE table_name
   SET column_name = PREG_REPLACE('regex_match', 'replacement_value', column_name);


This is third-party software but it uses the standard MySQL User-defined function interface to enable custom functions written in C/C++ to interact and behave like built-in functions (e.g., REPLACE()) ... but UDFs are essentially plug-ins that can be installed and uninstalled without having to recompile the server or even having to shut it down and restart. 

Above, the 'regex_match' and 'replacement_value' are the regular expression and replacement values, which can be from columns, variables, or supplied in the query as string literals.  In the last case, they need to be quoted.