[thelist] Mysql regexp

[r937]

...  regexp '^[a-z]*smith[a-z]*,$'

or

...  regexp '^[a-z]{0,}smith[a-z]{0,},$'

or

...  regexp '^[[:lower:]]*smith[[:lower:]]*,$'

or

...  regexp '^[[:lower:]]{0,}smith[[:lower:]]{0,},$'