Member Avatar for Chronwin

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 '%=%'
  • 2 Contributors
  • 2 Replies
  • 103 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Chronwin
Member Avatar for Ezzaral

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

Member Avatar for Chronwin

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.