mysql contains code example

Example: t_sql contains

SELECT * FROM table WHERE Contains(Column, "test");