Re: how to search in wild search

[Christian Mack]

Mike ALmogy wrote:
> 
> Hi list.
> I wrote a little database and now i wan to search it with a wild search.
> 
> What i mean is that instead of putting the whole name i can just put one
> word or a part of a word and it will retrieve all the matches.
> 
> Thanks,
> 
> Mike

Hi Mike

Just use something like:
SELECT * FROM table WHERE name LIKE '%part%';

BTW:
You really should get a SQL book :)

Tschau
Christian