To delete all pingbacks in WordPress you can use the mysql query below.
DELETE FROM wp_comments WHERE comment_type = 'pingback';
To delete all pingbacks in WordPress you can use the mysql query below.
DELETE FROM wp_comments WHERE comment_type = 'pingback';
To TRIM a string in MSSQL you can use the following Userdefinedfunction Snippet.
CREATE FUNCTION dbo.TRIM(@inputString VARCHAR(MAX)) RETURNS VARCHAR(MAX) BEGIN RETURN LTRIM(RTRIM(@inputString)) END