select (str) like (pattern);  

Select 'JAVA' like 'java';

Select 'JAVA' like 'java   ';

Select 'MySql' like 'mysql';