Select where, and not getting values

Databases
1

I’m trying to run the following sql but its not pulling anything in:

SELECT * from account_db.images WHERE userid = '123' AND status = '1' AND logo = '1'

Any help?

Thanks

2

mysql is very forgiving about accepting strings as numbers and vice versa, however, the quotes around your values is not what is causing the query to return no rows

3

assuming userid, satus, and logo are INT’s (or another numeral type), dont put quotes around the values.

You also generally dont need to specify the database name in the table reference if you’ve already told the server you want to use a specific database.