Sql Wildcards Select HAS

[coolgames]

Hello, we're having a spam problem where a user spams:

websitename.com

and we blocked that... but now they're spamming like:

w e b sit e.c !! om

w!e!B!s!i!t!e!. !c!o!m
etc....


so how can we select a field that has the following chars:

e i p x w r a x

? no matter how they're displayed.... even like --> epixwrax, e p i x w ! r a x

I tried:

SELECT * FROM `commentary` WHERE comment LIKE  '%.%' '%c%' '%o%' 'm%' '%e' '%p%' '%i%' '%c%' '%w%' '%a%' '%r%' '%x%'

but that doesn't work when they put in symbols like:

e#p!i x w@ar#x

can i select a value where it has ALL the chars listed... (epixwarx)
thanks :)

[SLauren]

If you are specific to "e i p x w r a x" and maintain the order of the characters as you specified in the given word then, the following query might help:

SELECT * FROM tablename WHERE columnvalue LIKE  '%e%i%p%x%w%r%a%';

Thanks,
Lauren

[coolgames]

please delete this post mod --------------------

[coolgames]

hey, it is the same order but what if they insert characters between like spaces and stuff?

does it still work?

thanks a lot

[SLauren]

I tried with spaces also as an example and it worked.
You can try running the below sample query:

SELECT IF('lllle!g g ipg  ggxgg!wfff!rggg!affffx' like '%e%i%p%x%w%r%a%','eesde','nothing');

I put spaces in between also.

Thanks,
Lauren

[coolgames]

hello, sorry for bothering again but how can i execute that?

table = commentary
field = comments

can you please convert it onto this form --> SELECT * FROM `commentary` WHERE `comments` .......

and the site's name is epicwarx.

thanks so much!

[SLauren]

You can execute the sample query, which i posted, from mysql command line or query browser(Windows ).

The query can be written as:

SELECT * FROM `commentary` WHERE `comments` LIKE '%e%i%p%x%w%r%a%';

Thanks,
Lauren

[coolgames]

thanks once again so much :) it works!