SQL replace a column in table with where clause - Paste

Paste

Archive

Guest
- Login
- Register

SQL 53

SQL replace a column in table with where clause By micha on 1st June 2023 09:52:51 AM

// REPLACE the author name FROM serial TO micha
UPDATE `pastes`
SET `member` = REPLACE(`member`, 'serial', 'micha')
WHERE `member` LIKE '%serial%'

Recent Pastes

Elementor Sticky[...]

Jump to anchor / go[...]

WP CPT Custom Icon[...]

WP get assigned[...]

Linux / Ubuntu[...]

SQL replace[...]

Raw Paste

Login or Register to edit or fork this paste. It's free.