Regex that contain only alphanumeric and special characters in MySQL -

i'm trying select rows contain english , special characters in mysql using:

select * table column regexp '^[a-za-z0-9 \-\:\(\)\&\.\,\?]+$' 

i don't know wrong when try adding - : ( ) & . , ? ! ' | < >.

the special character want: - : ( ) & . , ? ! ' | < >

note when add characters character class, not have blindly escape of them, , if have escape them, must use double \\ backslash in mysql regex. however, not necessary. when place - hyphen @ start or end of character class, or right after posix character class, treated literal hyphen. other "special" characters need not have escaped in character class.

also, ' should doubled in single quoted string literal.

so, use

select * table column regexp '^[a-za-z0-9 :()&.,?!''|<>-]+$'