SQL- word appears twice

I would like to delete a record if the word "BLAST" appears more than once in the column named [BODY]

Possible?
TIgerVAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
DELETE FROM SomeTable
WHERE (LEN(BODY) - LEN(REPLACE(BODY, 'BLAST', ''))) >= 10
0
 
pareshprajapatiCommented:
delete from tabname where BODY like "%BLAST%BLAST%"

you can repeat "%BLAST" number of times you wish as per your number of  times criteria
0
All Courses

From novice to tech pro — start learning today.