How to use locate and position functions in Mysql _mysql

LOCATE (SUBSTR,STR)
POSITION (substr in str)
Returns the position of the substring substr the first occurrence in string str. If substring substr does not exist in STR, the return value is 0:
mysql> SELECT LOCATE (' Bar ', ' Foobarbar ');
-> 4
mysql> SELECT LOCATE (' Xbar ', ' foobar ');
-> 0

This function is multibyte-safe. In MySQL 3.23, this function is case-sensitive, and when in MySQL 4.0, if any argument is a binary string, it is case-sensitive.

LOCATE (Substr,str,pos)
Returns the position of the substring substr the first occurrence after the POS position in string str. If SUBSTR does not return 0 in str:
mysql> SELECT LOCATE (' Bar ', ' Foobarbar ', 5);
-> 7

This function is multibyte-safe. In MySQL 3.23, this function is case-sensitive, and when in MySQL 4.0, if any argument is a binary string, it is case-sensitive.

A typical example is:
Slect * FROM TableName where LOCATE (colum1,colum1,1) >0