Need help with REGEXP

[johnn]

Say I have a list of 3 key words: 'mi go home'.
Then user enters into a search area such as
'm go home'
that I will assemble them into a regexp such as
[(m)(go)(home)]

I would like to REGEXP in mysql to see if user enter any word matching keyword list by select
... searchwordField REGEXP '[(m)(go)(home)]';

'go' and 'home' match, but 'm' should not match 'mi', but it did.

How to use REGEXP correctly?
Thanks in advance,
John

[Chris82]

Hi!

I have tried it with the preg_* functions of PHP and found a regexp that will match what you are looking for.

I hope it works for mysql aswell:

$text = "m go home";
preg_match("/^m go home$/", $text, $result); 

The output will be:

Array
(
    [0] => m go home
)

It will not match if $text is for example "me go home".

I don't know the meaning of "[" and "]" in MySQL regexp but normally you define a character range with them.
I have tested the regexp you used and it will match
mo goh home as well, since the letters "o" and "h" are used in the word home.

Hope it helps.

--Chris

[Chris82]

Sorry, I think I misunderstood your post.

Maybe you can split the phrase the user enters into several REGEXP's

searchwordField REGEXP '^m{1} ' 
AND searchwordField REGEXP 'go '
AND searchwordField REGEXP 'home'

'^m{1} ' will match exactly one m at the beginning.

[johnn]

Thank you, Chris. I'm not sure how John Coggeshall can use regexp successfully in the article "Simple Search Engine":
http://www.zend.com/zend/spotlight/w...engine2may.php

By the way I used this instead in my search engine code:
"SELECT ... WHERE ... IN ($word1,$word2,$word3)"