sql.raw() does not get columns from Table object

sql.raw(`date_format(${MyTable.mycolumn}, "%d-%m-%Y") like "%${search}%"`) // This errors

sql.raw(`date_format(${MyTable.mycolumn.name}, "%d-%m-%Y") like "%${search}%"`) // This Works!
sql.raw(`date_format(${MyTable.mycolumn}, "%d-%m-%Y") like "%${search}%"`) // This errors

sql.raw(`date_format(${MyTable.mycolumn.name}, "%d-%m-%Y") like "%${search}%"`) // This Works!
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server