Return values similar/like search value 1

[cammy]

Hi

I have a website search page setup through dreamweaver and I would like the search to return results that are similar to or like the search term. At the moment, only exact matches are returned or all records if the search box is left blank (which I also need to happen).

The mysql code I have in the recordset is as follows:

SELECT * FROM database.table
WHERE dbfield LIKE 'vardbfield'

Any help would be great.

Cheers

Cammy

 

[r937]

use wildcard characters

... WHERE dbfield LIKE '[red]%[/red]vardbfield[red]%[/red]'


r937.com | rudy.ca

 

[cammy]

Thanks.

Jeez. I'm such a numpty at this. I scare myself sometimes.

Cheers

Cammy

 

[feherke]

Hi

For such simple expression the [tt]instr()[/tt] function could be enough :

[b]select[/b] * [b]from[/b] database.table
[b]where[/b] instr(dbfield,[i]'vardbfield'[/i])>0;

The wildcard matching is usually slower then searching for a substring.

Feherke.

http://rootshell.be/~feherke/