SQL Query

[Django x2]

Chaps

I have a table with MAC Addresses in, loads in fact.

I need to clear the table completely, but not the columns, just the data in the columns. I can't write 'NULL' to the table as it's protected from that and I don't really want to change it.

Instead, I've used a wildcard query to remove MAC addresses.

Let's say, I have MACs that start with 9C, EC and 08.

delete from table where macaddress like '9C:%'

will remove any MAC address entry that starts with 9C - fine

But, how do I make the query so that I can easily say, delete from table where macaddress like 9C, EC, 08, etc, etc, etc?

Thanks

 

[Django x2]

Cool, that's what I thought, thanks

 

[Django x2]

If I do DELETE FROM mytablename I get "Invalid Object Name mytablename"