anton-roos

UPDATE  `wp_cf7dbplugin_submits`
SET  `field_name` = REPLACE(`field_name`, 'tel-123', 'tel-576')
WHERE  `field_name` LIKE 'tel-123%';

anton-roos

<script>
  document.write(new Date().getFullYear())
</script>

anton-roos

/* Delete all bounced email addresses from list 13 */
DELETE FROM `subscribers` WHERE `bounced` = 1 AND `list` = 13;

/* Delete all marked as spam email addresses from list 5 */
DELETE FROM `subscribers` WHERE `complaint` = 1 AND `list` = 5;