MySql Regexp

[rgoyal]

Following is the requirement for search component: Input: Only 1 search box in which I will put 1 or more words(separated by space) Output: I need to search space separated parts of this string in multiple fields of multiple tables. What I have done?

$keywordList = explode( ' ', trim($_REQUEST['txtSearch']) );

$i = 0;

while($i < count($keywordList)){

    $strKeyword.= "
    r.userId like '%$keywordList\[$i\]%'
or r.maritalStatus like '%$keywordList\[$i\]%'
or r.nativeLang like '%$keywordList\[$i\]%'
or ro.personalStatement like '%$keywordList\[$i\]%'
or ro.empReq like '%$keywordList\[$i\]%'
or ro.hobbies like '%$keywordList\[$i\]%'
";

$i++;

if($i < count($keywordList)){
	$strKeyword.= " or ";
}

}

This is working according to my requirements I need to do it in MySql and PHP with regexp. Any Help? Thanks