Hello, I have a website that's create a search history, but some users search for "pr0n" and i don't want that the search history show it in the homepage.

I know how to do it for a single keyword, example:

PHP Code:

<?
require_once("includes/config.php");

// Delete Bobby from the "example" MySQL table
mysql_query("DELETE FROM history WHERE query='sex") 
or die(mysql_error());  
?>

But it will just delete the query "sex" and don't "sex-tape", "sex-anything" or "sex-example".

What I want do is create a badwords list and ANY query if include this words in the query will be deleted via cronjobs.

"Fast" don't will delete just the query "Fast" but the queries "Fast", "Fast-job" or "Fast-anything".

Use wildcards and a LIKE criteria

WHERE query LIKE '%sex%'

but be aware that it will match such things as

"Sussex", "sextuplet" & "expertsexchange.com"

Originally Posted by chrishirst

Use wildcards and a LIKE criteria

WHERE query LIKE '%sex%'

but be aware that it will match such things as

"Sussex", "sextuplet" & "expertsexchange.com"

It's Working.

You may use regexp instead of like, it will give you more flexibility (traded for speed)

[[:<:]], [[:>:]]

These markers stand for word boundaries. They match the beginning and end of words, respectively. A word is a sequence of word characters that is not preceded by or followed by word characters. A word character is an alphanumeric character in the alnum class or an underscore (_).

mysql> SELECT 'a word a' REGEXP '[[:<:]]word[[:>:]]'; -> 1
mysql> SELECT 'a xword a' REGEXP '[[:<:]]word[[:>:]]'; -> 0