SQLite query - using [] in SQLite queries

Question

Dear Sirs

I would like to know if it is possible to use [] in SQLite query as we used to in Access and other DB.

e.g. SELECT * FROM mytable WHERE fwords like '%b[e,i,a]d%'

this will retrieve all rows have fwords containing bad, bed, bid

Thanks a lot

Answer 1

From http://www.sqlite.org/lang_expr.html:

The LIKE operator does a pattern matching comparison. The operand to the right of the LIKE operator contains the pattern and the left hand operand contains the string to match against the pattern. A percent symbol ("%") in the LIKE pattern matches any sequence of zero or more characters in the string. An underscore ("_") in the LIKE pattern matches any single character in the string. Any other character matches itself or its lower/upper case equivalent (i.e. case-insensitive matching).

Does that help?

Answer 2

You can have a look at the regex section here.