RE: [PHP] Search MySQL and Match Whole Words
| From: | Jay Blanchard | Date: | Fri, 23 Apr 2004 12:21:31 +0000 |
| Subject: | RE: [PHP] Search MySQL and Match Whole Words | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-184383@lists.php.net to get a copy of this message | ||
[snip]
I was wondering if anyone knows how to do whole word searches in mysql.
I
have a search textbox that users can enter in multiple words to search
for
in the database, but things like the mysql LIKE match any part of a
word.
Is there a way to search for whole word matches only? Please let me
know if
you can help.
[/snip]
the following might not be the most efficient way...and not tested
use explode to seperate the words placed in the form field
$arrayWords = explode(" ", $_POST['seach_box'])
then do query with loop to populate IN statement
$getData = "SELECT stuff FROM table ";
$getData .= "WHERE column IN (";
for($i = 0; $i < count($arrayWords); $i++){
if($i != (count($arrayWords)-1)){
$getData .= "'" . $arrayWords[$i] . "',";
} else {
$getData .= "'" . $arrayWords[$i] . "'";
}
}
$getData .= ") ";
$dbData = mysql_query($getData, your_connection_string);