Member Avatar for eman neercs
eman neercs -1 Newbie Poster

I have 2 fields in my db, the first is Title and the other StopList.

If a StopList word appears in any of the Title names, I want to flag that item for deletion.

Currently using a PHP array to do this but wanted to know if mysql could do it

e.g. Delete from "Title" where "title.name" like "stoplist.word"

Can't quite see how to do it.

  • 1 Contributor
  • 0 Replies
  • 95 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.