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 Rhinorhino 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
Joined
Sep 12, 2005
Messages
290
Location
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
The column contains an actual file (pdf, doc or xls)...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top