SQL Patch question - help please!

[mc12345678]

Thinking could add a criteria to the where statement (or pretest for such existing conditions) such as

AND categories_name not like '%&%'

[lat9]

You could, but what about the other HTML symbols, e.g. <? That will be converted to <.

[Feznizzle]

Haha! I found that out the hard way!

It worked for categories because no other instances of '&' existed, such that it was being used for html entities. So I then applied it to a zillion product titles, many of which were using it.

DOH!

Thank you so much for your input!