Replace a String in a MySQL table using JOOQ

Question

UPDATE table
SET field = REPLACE(your_field, 'original_string', 'replace_string')
WHERE your_field LIKE '%original_string%'

Is there a way I could execute above query with JOOQ?

Lukas Eder · Accepted Answer · 2017-11-22 17:51:36Z

3

Yes, it translates pretty much 1:1. Just write it out like this:

using(configuration)
  .update(TABLE)
  .set(TABLE.FIELD, 
       replace(TABLE.YOUR_FIELD, "original_string", "replace_string"))
  .where(TABLE.YOUR_FIELD.like("%original_string%"))
  .execute();

The DSL.replace() method is documented in the Javadoc

The following static imports are assumed:

import static org.jooq.impl.DSL.*;
import static com.example.your.schema.Tables.*;

answered Nov 22, 2017 at 17:51

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace a String in a MySQL table using JOOQ

1 Answer 1

The following static imports are assumed:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

The following static imports are assumed:

Comments

Your Answer

Sign up or log in

Post as a guest

Related