search boxes with more than one keyword

jbbaxx

Hi,
What is the necessary code to return a recordset from a single text box with more than one keyword in it (like most search engines do)?
Thanks

chingwaah

try looking into MySQL FULLTEXT search.

jbbaxx

Thanks. By the look of it, this is all in the MySql. Is there any PHP necessary to help this along?

mikesgt2

Or you could do this:

<?php
$searchterm = 'more than one word';

$sql = "SELECT * FROM table WHERE field REGEXP '".str_replace(' ','|',$searchterm)."'";

/*
	Then go on to execute the query...
*/
?>

richie

mikesgt2,

It works for me, but only when used with just a single mysql table column. Can it be modified to work with more than one column at once?

Richie.