Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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 & some html tags i need to delete all img tags from this coulmn what can i do to achieve this ?
this is my ReGex
/</?(?i:img)(.|\n)*?>/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.
