mysql>mysql> SELECT 'abcd' LIKE '%bc%';+--------------------+| 'abcd' LIKE '%bc%' |+--------------------+| 1 |+--------------------+1 row in set (0.00 sec)