Filter strings in where clause with regular expression (regex)

[ropitz-wago]

Hey!

Is there a solution to look up a string value via regex in the where clause?

If not implemented, my idea:

select * from table where name = /<regexstring>/;

I searched for these questions in the documentation, threads and discussions.

Thanks

[tobiemh]

Hi @ropitz-wago this should already be possible! Have you tried it?

[SergioKingOne]

Hi.

Can I use index with regex. Trying to do so but it is not doing it. Tried full text search index and normal index.

[bitdom8]

Already doable like this in Nodejs: res = await db.query(SELECT * FROM article WHERE text = /(?i)bitfinicon/ ORDER BY t DESC);

"bitfinicon" is what you try to find

[mateodelnorte]

Does this have greater, equal, or reduced performance compared to ~?