Curtis2
Curtis2

Reputation: 116

Why it returns 0 results even if where clause has matches

I'm facing a very weird problem:

I have two tables (and only two tables) in my MySql database, this is how they look like: enter image description here enter image description here

select * from records select * from user_profile

As you can see, both table has an entry with the same user_id: 00000c289a1829a808ac09c00daf10bc3c4e223b

The problem is, if I execute

select * from records where user_id = "00000c289a1829a808ac09c00daf10bc3c4e223b"

database does return a result with 0 rows, while the same where clause will return one row correctly on user_profile table.

Any idea?

Upvotes: 0

Views: 38

Answers (1)

Curtis2
Curtis2

Reputation: 116

As @vijayrami pointed out, it's "".

Upvotes: 1

Related Questions