[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Query XML in a database table

Hi,
I need to query a column in a database containing XML, I would like to delete all rows that do not contain the word Receipt in the XML?
could someone help with this please?

Regards,
Atorex
0
atorex
Asked:
atorex
  • 3
1 Solution
 
plusone3055Commented:
DELETE FROM <your table>
WHERE <your column>   NOT LIKE '%receipt%'
0
 
plusone3055Commented:
DELETE FROM <your table>
WHERE <your column>   NOT LIKE '%receipt%'
0
 
atorexAuthor Commented:
thanks, I used the not like but did not use the %, knowledge is a beautiful thing!

thanks.
0
 
plusone3055Commented:
no problem have a great day
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now