Search query bug

[adrian_quah]

Hallo there 🙂

I'm doing an internal search engine for my site. What it does is to return the description, and link for a query returned. All these entries are kept in an MySQL database.

The prob is that when a user types in "yes", all entries containing "y" or "e" or "s" are returned. Not very efficient query, huh?

I'm using the SQL expression
$get_match=".... WHERE entry REGEXP \"$search_query\"..."

The $search_query has been exploded and imploded thus the reults is somewhat like [(yes)].

Any ideas for a more efficient SQL search query? Thanx a lot!

[Anon]

why not this ?

$get_match = ".... WHERE entry like '%$search_query%'"

[Anon]

Thanks, I'll try it 🙂 and let u know the outcome okay. Appreciate the many kind ppl on this Forum. It's made learning PHP a great experience.

David R wrote:

why not this ?

$get_match = ".... WHERE entry like '%$search_query%'"