DB search query

djavet · #1 (**permalink**) 09-23-05, 09:40

Hello

I've a query for searching a contact name:

Code:

SELECT *
FROM contacts, pays
WHERE 
(
nom like '%SearchString%' or  
web_url like '%SearchString%' or  
organisation like '%SearchString%' or 
pays like '%SearchString%'
) 
AND 
contacts.code_pays_rel=pays.code_pays
ORDER BY organisation, nom ASC

My contact name: Bokhandel Peter Eggertz

Per exemple:
I give as keyword "ter egg", I found the name, but if I give "egg ter", it doesnt work or if "bokhan eggertz" it doewsn't work too.

How can I make this to find the contact?

A lot of thx for yoru help and time.
Regards, Dominique