0

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
3
Views
6 Years
Discussion Span
Last Post by Chronwin
0

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

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.