Miva - MySQL Regex Validation

miva-mysql-regex-validation.xml

<!--
https://www.miva.com/forums/forum/designers-and-developers/mivascript-miva-merchant-empresa/8538-regular-expressions#post171523
-->

<mvt:assign name="g.Pattern" value="'^Foo(bar)?'" />

<mvt:assign name="l.settings:query:query" value="'SELECT \'foo\' REGEXP ?'" />
<mvt:assign name="l.settings:query:bind_parameters[1]" value="g.Pattern" />
<mvt:item name="sql" param="l.settings:query" />
Foo=&mvt:query:results;

<hr>

<mvt:assign name="l.settings:query" value="''" />
<mvt:assign name="l.settings:query:query" value="'SELECT \'Foobar\' REGEXP ?'" />
<mvt:assign name="l.settings:query:bind_parameters[1]" value="g.Pattern" />
<mvt:item name="sql" param="l.settings:query" />
Foobar=&mvt:query:results;

<hr>

<mvt:assign name="l.settings:query" value="''" />
<mvt:assign name="l.settings:query:query" value="'SELECT \'baz\' REGEXP ?'" />
<mvt:assign name="l.settings:query:bind_parameters[1]" value="g.Pattern" />
<mvt:item name="sql" param="l.settings:query" />
baz=&mvt:query:results;