Keyword command?

dfownz

Is there a php or mysql command that searches for words that are close to or almost match a variable?

For example, instead of needing to type "High Street" to get a results in a query, "High", "high st.", and "High St." would all get the same results as "High Street" would get.

I hope yall understand what I'm trying to say.

Thanks,
DF

BooRadLey

$sql = "SELECT * FROM table WHERE field LIKE ".$string;

Hope this helps,

Brad

*edit I know that there are more options with this, like using wildcards and such, but I haven't used it much myself so I can't help you out with that.

dfownz

Thanks,

is it necessary to have the " .$string at the end?

I don't get what .'s do in php.

Thanks

BooRadLey

The . concatenates (sp?) it attaches strings / variables / etc... together

$string = " world";
echo "hello".$string;

//Outputs hello world

You dont have to have a variable there if you want you can do:

$sql = "SELECT * FROM table WHERE field LIKE 'macaroni'";

All the variable does is allow you some flexibility with the query. Depending on what is assigned to the variable will change the query and change your output.

Hope this helps,

Brad

dfownz

It definetly helps,

But I have a two word variable (street name) and when I was doing that it didn't come up with any results unless i typed in the street name correctly like "High Street".

simply "High" would not get any results. Either would "High Stree"...

🙁

Thanks

BooRadLey

ahh ok, I looked up on LIKE a bit and learned a bit, try this:

$sql = "SELECT * FROM table WHERE field LIKE '%".$string."%'";

The equivalent without the variable is:

$sql = "SELECT * FROM table WHERE field LIKE '%macaroni%'";

That will search for your phrase as well as allow characters before and after the phrase.

I hope this helps,

Brad

dfownz

Word!

Thanks