D1_ERROR: near "in": syntax error at offset 153

I can't seem to use inArray with d1:

D1_ERROR: near "in": syntax error at offset 153

D1_ERROR: near "in": syntax error at offset 153

With

const result = await db
.select()
.from(posts)
.where(  
  and(  
    inArray(posts.content, ["book"] ),
    eq(posts.isActive, true) 
  )
)

const result = await db
.select()
.from(posts)
.where(  
  and(  
    inArray(posts.content, ["book"] ),
    eq(posts.isActive, true) 
  )
)

Any suggestions?

1 Reply

cosbgnOP•5mo ago

Wrong table - don't mind me