Tag Info

New answers tagged


You can use Regex with UDFs (user-defined functions). What you need is to create a Function that will call a Regex library. After that, your SQL will call this Function to execute the Regex. First, read the following article as an example. It says that you can create this Function as: CREATE FUNCTION regex1(pattern VARCHAR(2048), string CLOB(10M)) ...


It's a totally pointless function that executes arbitrary SQL. It isn't SECURITY DEFINER so the only risk I think it can pose is if you allow users to run arbitrary SQL predicates or call arbitrary functions (in which case you're probably already stuffed) but try to block them from running any command they want. As you guessed, it just executes the SQL ...

Top 50 recent answers are included