DT
Drizzle Teampatwoz

sql where column md5

Hey, how can I achieve the following statement in drizzle? 
-- mysql

SELECT * FROM podcasts_title
WHERE MD5(guid)='baf59ee6be7bf0cc8140038d7cd641b4'
--    ^^^^^^^^^
-- mysql

SELECT * FROM podcasts_title
WHERE MD5(guid)='baf59ee6be7bf0cc8140038d7cd641b4'
--    ^^^^^^^^^
await db
    .select()
    .from(podcastsTitle)
    .where(
      eq(podcastsTitle.guid, songId)
      // ^^^^^^^^^^^^^^^^^^
    )
await db
    .select()
    .from(podcastsTitle)
    .where(
      eq(podcastsTitle.guid, songId)
      // ^^^^^^^^^^^^^^^^^^
    )
patwoz
patwoz•19d ago
Solution: 
eq(sql`MD5(guid)`, songId)
eq(sql`MD5(guid)`, songId)
Want results from more Discord servers?
Add your server
More Posts
Error on Query Filter: Types of property 'table' are incompatible.I'm currently trying to filter a query as [explained in on the docs](https://orm.drizzle.team/docs/rHow to do Computed Fields / Manipulate data at Query Level?I'm looking for something like this, on prisma we can validate fields when querying the model. I coupgEnum conversion not working as expectedI have the following pgEnum defined: ``` export const ApprovalRequestTypePgEnum = pgEnum('approval_Filtering a jsonb with the shape Array<{id:string,name:string}>Hi. I have a query that returns all the posts with it's categories like this, ```typescript type Pos