Prisma•2w ago

TypedSQL Apostrophe

When I pass an apostrophe in a string argument to a typed sql query, i don't get the expected results.

-- selectBook.sql
SELECT * FROM book AS b WHERE b.name LIKE CONCAT('%', ? ,'%');

-- selectBook.sql
SELECT * FROM book AS b WHERE b.name LIKE CONCAT('%', ? ,'%');

client.$queryRawTyped(selectBook("Dante's Inferno"))

client.$queryRawTyped(selectBook("Dante's Inferno"))

If I pass "Dante", it works. If I pass "Dante's", then it doesn't work. I'm connection to MariaDB

3 Replies

Prisma AI Help•2w ago

Ahoy, knowledge seeker! I'm the Prisma AI Help Bot. Do you want a dev's response that might take a hot second, or an AI answer that's ready before your next coffee sip? Either way, your question is important to us.

Nurul•2w ago

Do you get the correct output if you run this SQL directly against your db? SELECT * FROM book AS b WHERE b.name LIKE '%Dante''s%';

joel.rainearwillsOP•2w ago

yes Here's the query and result with my test data. I'm using MariaDB version 11.8.2-MariaDB-ubu2404-log, Node v22.16.0, and @prisma/client": "^6.10.1"

SELECT id, payees, description, date FROM financial_transaction ft WHERE ft.payees LIKE CONCAT('%', 'McDonald''s','%');

SELECT id, payees, description, date FROM financial_transaction ft WHERE ft.payees LIKE CONCAT('%', 'McDonald''s','%');

// Results
id    payees    description    date
3    McDonald's    McDonalds #3322    2025-08-14
17    McDonald's    McDonalds #3322    2025-07-15
23    McDonald's    McDonalds #3322    2025-06-15
29    McDonald's    McDonalds #3322    2025-05-16
35    McDonald's    McDonalds #3322    2025-04-16
41    McDonald's    McDonalds #3322    2025-03-17
47    McDonald's    McDonalds #3322    2025-02-15
53    McDonald's    McDonalds #3322    2025-01-16
59    McDonald's    McDonalds #3322    2024-12-17
65    McDonald's    McDonalds #3322    2024-11-17
71    McDonald's    McDonalds #3322    2024-10-18
77    McDonald's    McDonalds #3322    2024-09-18
83    McDonald's    McDonalds #3322    2024-08-19

// Results
id    payees    description    date
3    McDonald's    McDonalds #3322    2025-08-14
17    McDonald's    McDonalds #3322    2025-07-15
23    McDonald's    McDonalds #3322    2025-06-15
29    McDonald's    McDonalds #3322    2025-05-16
35    McDonald's    McDonalds #3322    2025-04-16
41    McDonald's    McDonalds #3322    2025-03-17
47    McDonald's    McDonalds #3322    2025-02-15
53    McDonald's    McDonalds #3322    2025-01-16
59    McDonald's    McDonalds #3322    2024-12-17
65    McDonald's    McDonalds #3322    2024-11-17
71    McDonald's    McDonalds #3322    2024-10-18
77    McDonald's    McDonalds #3322    2024-09-18
83    McDonald's    McDonalds #3322    2024-08-19

Gaming

Programming

TypedSQL Apostrophe

Did you find this page helpful?