Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Attachments for Table

Status
Not open for further replies.
jasonhuibers

jasonhuibers

Programmer
Sep 12, 2005
290
CA
A column in my Table1 contains pdfs, docs and xls as attachment types. Is there a query that I can use to delete specific types in that column. IE: delete from table1 where type = 'pdf'
I only want to delete the PDF types....
 
Sort by date Sort by votes
Have you tried:
[tt]delete from table1 where type = 'pdf'[/tt]

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
155
mmiah1982
mmiah1982
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
134
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
105
harfri
harfri
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
105
mikrom
mikrom
Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
208
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top