Reputation: 961
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';
Upvotes: 1
Views: 1188
Reputation: 905
use OR
instead of AND
delete from TF
where WORD='of' OR WORD='and' OR WORD='the';
Upvotes: 5