Skip to Content
0
Former Member
Oct 29, 2015 at 03:45 PM

Impex: Update query for Batchmode=true

891 Views

Hi I have a table like below. I need to make the active=false for the text that has 'AA' using update impex by keeping batchmode=true

sample SQL update query: UPDATE table_name set active=false where text like '%AA%'

 __________________________
 |PK | ACTIVE | TEXT        |
 |_________________________|
 | 1 | true        | BBAABB |
 | 2 | false       | BBCCBB |
 | 3 | true        | BBAABB |
 ___________________________