How to use Regular Expressions when searching?

[vrxiaojie]

I'm used to search LCSC number like 'C2175 C2176' . However, when I search 'C217' it shows result including 'C2175 C2176'. I just want it shows the result of LCSC number 'C217 '.

How should I write the Regular Expression for it ?

I've tried \bC217\b and it didn't work.

[jbtronics]

You dont add any delimiters chars, just put the regex expression into the seach and enable regex mode in search options.
You probably want something like ^C217$ in your case, to get only exact matches.

The available regex functionality and syntax available depends on your database type (and sqlite uses PHPs regex, so PCRE syntax),

[vrxiaojie]

Thank you!