1 reply

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

I can't seem to use

inArray

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?