RE: Blacklist

[Gordon Bissell]

> I want to create a table that holds phonenumbers that are blacklisted.
> And then check a number against this table to see if it 
> blacklisted or not.
> The problem I have is that I want to add entries with wildcards.
> 
> e.g. 0800* should match all numbers starting with 0800.
> 
> How do i INSERT this rows and how do I write the SELECT
> 
> /pelle

Try something using: LIKE '0800%'