mercredi 8 août 2018

MYSQL Inquery: If a cell is empty then

I am a noob at MYSQL (so keep that in mind, haha).

I am looking for a if/then query that does the following...

Table = schedule_table
Columns = invoice_number, archive

In schedule_table, if invoice_number is not empty then fill archive with yes.

I appreciate any help. Thanks!

Aucun commentaire:

Enregistrer un commentaire