I've been knocking my brains for a while with this one.
I need to search a particular table for any records that contain an equal sign =.

This works for any criteria except = :

SELECT id, mystuff FROM db1_user WHERE email LIKE '%=%'

Perhaps where instr(email, '=') > 0

Perhaps where instr(email, '=') > 0

Works like a charm.
LOL, I feel incompetent. I can't believe I didn't think of that.

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.