python - Modify query to exclude soft deleted records

Question

Python code part that contains query:

conn = pymysql.connect(host='127.0.0.1', user=sql_username,

        passwd=sql_password, db=sql_main_database,

        port=tunnel.local_bind_port)

query = '''select * from users;'''

df_user = pd.read_sql_query(query, conn)

I need to to modify query to exclude the soft deleted records. How modified query should look like?

question from:https://stackoverflow.com/questions/65838209/modify-query-to-exclude-soft-deleted-records

Answer 1

Waitting for answers