'Failed to run sql query column 'where clause argument' does not exist'

I have created a test table "table_name" with a single row.

This is my row:

   id     |  design_id(varchar)
-------------------------------
   1      |      B08YML3ZSS

   id     |  design_id(varchar)
-------------------------------
   1      |      B08YML3ZSS

When I run

SELECT * 
FROM table_name
WHERE id = 1;

SELECT * 
FROM table_name
WHERE id = 1;

I get the correct result. But when I try

SELECT * 
FROM table_name
WHERE design_id = "B08YML3ZSS";

SELECT * 
FROM table_name
WHERE design_id = "B08YML3ZSS";

I get an error

Failed to run sql query: column "B08YML3ZSS" does not exist

Failed to run sql query: column "B08YML3ZSS" does not exist

Supabase•4y ago•

2 replies

I have created a test table "table_name" with a single row.

This is my row:

   id     |  design_id(varchar)
-------------------------------
   1      |      B08YML3ZSS

   id     |  design_id(varchar)
-------------------------------
   1      |      B08YML3ZSS

When I run

SELECT * 
FROM table_name
WHERE id = 1;

SELECT * 
FROM table_name
WHERE id = 1;

I get the correct result. But when I try

SELECT * 
FROM table_name
WHERE design_id = "B08YML3ZSS";

SELECT * 
FROM table_name
WHERE design_id = "B08YML3ZSS";

I get an error

Failed to run sql query: column "B08YML3ZSS" does not exist

Failed to run sql query: column "B08YML3ZSS" does not exist