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


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


Any suggestions?
Was this page helpful?