Searcing Mysql by Like n Regex

SELECT * FROM m_cities WHERE   NAME REGEXP "^.{7}$"
SELECT * FROM m_cities WHERE   NAME REGEXP "^....."
SELECT * FROM m_cities WHERE   NAME REGEXP "w"
SELECT * FROM m_cities WHERE NAME LIKE '__E__K'
SELECT * FROM m_cities WHERE   NAME LIKE "%TA%"