I am having a table TF with rows FILEID, WORD, FREQUENCY. I am trying to delete all word rows with word 'and' 'of' 'the' from the table. Below is my query. It is not doing anything.
delete from TF
where WORD='of' AND WORD='and' AND WORD='the';
use OR instead of AND
delete from TF
where WORD='of' OR WORD='and' OR WORD='the';
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments