Untitled

Search   replace mySQL data
Text Text Text Text Text
[swordfish filename=code.bas]
code code code
123
code code[/swordfish]
Text Text Text Text Text

Text Text Text Text Text
[code]
code code code
123
code code[/code]
Text Text Text Text Text

$regexp = '/[(/)?swordfish[^]]*]/';

$push = 'REPLACE whatever_table (id, post_text)
          VALUES';

$pull = 'SELECT id, post_text
           FROM whatever_table
          WHERE whatever = condition';

if ( $result = $mysqli->query($pull) ) {
    while ( $row = $result->fetch_assoc() ) {
        $row['post_text'] = preg_replace($regexp, '[$1code]', $row['post_text']);

        $push .= sprintf(
            ' ("%s", "%s"),',
            $mysqli->real_escape_string($row['id']),
            $mysqli->real_escape_string($row['post_text'])
        );
    }

    $result->free();
}

$mysqli->query(rtrim($push, ','));