How do define REGEX or REGEXP function in expo-sqlite

Question

I am building an Expo app using expo-sqlite and TypeOrm through DataSource to interact with the mobile device built-in sqlite DB.

I need to use a regex matching function in a database query.

Here is my TypeOrm DataSource:

import * as SQLite from 'expo-sqlite'

new DataSource({
  database: 'db-name',
  type: 'expo',
  driver: SQLite,
  entities: [...entities],
  synchronize: true,
  logging: 'all',
})

Whenever I use REGEXP function as follows

const dataSource = await getDataSource()
const usersRepository = dataSource.getRepository(User)
const query = usersRepository.createQueryBuilder('user')

query.where(`user.name REGEXP 'stringQuery'`)

I get the error:

Error code 1: no such function: REGEXP

How can I define the REGEXP function or any other regex matching functionality?

I did read this article before, the problem is that with expo-sqlite i don't have an access to createFunction or loadExtension methods to apply this — Ahmed Afifi
– Ahmed Afifi, Commented Apr 30 at 11:08

react Raylogic · Accepted Answer · 2025-07-01 12:37:55Z

1

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%` })

edited Jul 1 at 12:37

answered Jul 1 at 12:08

react Raylogic

818 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do define REGEX or REGEXP function in expo-sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related