Simple reg exp +MySQL

Have been trying to figure out regular expressions for a while now, but learning slooow 🙂
So I hope somebody could help me out on this one:

How can I pull out all records where the user name starts with either a, b or c?

regards Thomas

You can use either of the following -

SELECT *
FROM user
WHERE username REGEXP '^a'
OR username REGEXP '^b'
OR username REGEXP '^c'

SELECT *
FROM user
WHERE username LIKE 'a%'
OR username LIKE 'b%'
OR username LIKE 'c%'

Hope this helps 😉

Your regex is "match the start of the string followed by a character class containing either a, b, or c"

"start of the string" means use the caret symbol '^'.

"a, b, or c" means use a character class (any one of the characters listed inside a pair of square brackets [] ).

SELECT *
FROM user
WHERE username REGEXP '^[abc]'