Question Details

No question body available.

Tags

regex react-native sqlite typeorm expo-sqlite

Answers (1)

July 1, 2025 Score: 1 Rep: 73 Quality: Low Completeness: 50%

Error no such function: REGEXP happens because SQLite does not include a built-in REGEXP function by default. Unlike LIKE or GLOB, REGEXP is a user-defined function that needs to be manually registered with the SQLite engine.

Use LIKE or GLOB instead of REGEXP

query.where("user.name LIKE :pattern", { pattern: %stringQuery% })