Q-ximi
Q-ximi

Reputation: 961

Delete rows from table

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

Answers (2)

Juraj Petrik
Juraj Petrik

Reputation: 905

use OR instead of AND

delete from TF
where WORD='of' OR WORD='and' OR WORD='the';

Upvotes: 5

potashin
potashin

Reputation: 44601

delete from TF where word in ('of','and','the')

Upvotes: 3

Related Questions