regexp for mysql 5.1 (look up entry based on user input)

How do I write a regular expression which checks for entries that contain开发者_运维技巧 within them, a specific character pattern input by the user. For instance,

User input: at

Desired return: cat,at,atom,distillate,

SELECT * FROM table WHERE column LIKE '%at%'