sunshne2263
sunshne2263
PostsComments
DTDrizzle Team
Created by sunshne2263 on 12/25/2023 in #help
Help Needed: Adding Message Count and Filtering by UserId in DB Query
it appears if i use 
db.select()
  .from(companion)
  .leftJoin(
      message,
      and(eq(companion.id, message.companionId), eq(message.userId, userId)),
    )
  .where(eq(companion.id, params.chatId))
  .orderBy(asc(message.createdAt))
db.select()
  .from(companion)
  .leftJoin(
      message,
      and(eq(companion.id, message.companionId), eq(message.userId, userId)),
    )
  .where(eq(companion.id, params.chatId))
  .orderBy(asc(message.createdAt))
I get the messages, I was just wondering if there was a way to include the count?
7 replies
DTDrizzle Team
Created by sunshne2263 on 12/23/2023 in #help
Is FULLTEXT Search Possible in MySQL via FULLTEXT Index?
Thank you!
5 replies