Got problem to search an exactly word

ngu_tri

hi everyone, when i tast in something to search and searching gives me everything. But i want to search an exactly word for example "IT" and then it will display only IT. I could not solve the problem and need help. thanks.

search.php

<?php
include("dbconnect.php");
$search=$_POST["sokord"];
if(!$search)
{
echo("Tast inn a search. <a href='sok.php'>Try again</a>");
}
else
{
$result=mysql_query("SELECT *FROM media WHERE Sokord LIKE '%$search%'");
if(mysql_num_rows($result) <= 0)
{
echo (mysql_num_rows($result))." Match. <a href='sok.php'>Prøv igjen</a><br> ";
}
else
{
echo (mysql_num_rows($result))." Matches<br>";
}
while($r=mysql_fetch_array($result))
{
$Sokord=$r["Sokord"];
echo "<a href='sokordlink.php?Sokord=$Sokord'>[ $Sokord ] </a>";
}
}
?>

sfullman

if you want to match a WORD, so that "it" does not get

kite
mitten
etc..

then your query should be something like this:

.. FROM table WHERE field REGEXP '\s+$fullWord\s+'

the \s+ means "white space, at least once"

to be precise, though, that would miss fields starting or ending in "it", right? (no white space). So this is better:

.. FROM table WHERE field REGEXP '(^{|\s)$fullWord($|\s)'}

where ^|\s means either beginning of the string OR whitespace would work, and ($|\s) means either end of string OR whitesapce would work.

MAKE SURE you have an index on the field you're searching if possible; on large dbs this query could run more slowly.

Sam

ngu_tri

hello. I did as you said, but it does not display anything, only blank site. So what wrong is it?? Thanks