Proper startsWith sql query

[opaque crescent]

Ask ChatGPT for help with SQL, it makes it much easier to figure out

[limber escarp]

duh 😢

[opaque crescent]

// Assuming db is an instance of a database connection
const startsWithQuery = db.query('SELECT key, value FROM db WHERE key LIKE $prefix ESCAPE \'\\\'');

// usage
export async function list($prefix: string) {
  const escapedPrefix = $prefix.replace(/[%_]/g, '\\$&');
  
  try {
    const results = await startsWithQuery.all({ $prefix: escapedPrefix });
    return results;
  } catch (error) {
    // Handle the error
    console.error('Error executing query:', error);
    throw error;
  }
}

[limber escarp]

thanks

Does replace with g do the same thing as replaceAll tho

Oh, it does

Thanks