regex for this string in mysql

Question

I have these rows:

db666405.gallery
db666405.table1
db666405.table2

I want to capture the word after the dot.

How to do with regex in mysql?

I have tried with ^\. or [.], but I did not succeed.

SELECT *
FROM `table`
WHERE `column` REGEXP '^\\.' 

Answer 1

To select any columns that have the word Gallery, you can use a

SELECT *
FROM `table`
WHERE `column` LIKE '%gallery%' `

This will return all that have gallery

Answer 2

MySQL regex doesn't "capture" anything. It's for matching only; there is no support for regex replacement in MySQL.

I assume you want to return the part after the dot:

select *, substring(`column`, instr(`column`, '.') + 1) as ext
from `table`
where `column` like '%.?%'