multible like %TEXT%

[madsm]

Hi,

is it possible with one sql query to perform a SELECT * FROM articles WHERE headline LIKE %$text% OR artText LIKE %$text%

something like that?!?!?!?

thanks!

[[deleted]]

yes, exactly like that, but with quotes around the %$text%

Tip: the MYSQL manual contains all the syntax of all the possible queries that MySQL knows.

[Anon]

You could use FULL TEXT SEARCH, see mysql manual, but for me that didn't work. I made another approach:

$searchfield = stripslashes(str_replace(" ","%\' OR column LIKE \'%",$searchfield));

$query="SELECT *
FROM table WHERE column LIKE '%$searchfield%'";

It replaces a whitespace with OR column LIKE

So when you search for two words your query will become:

SELECT * FROM table WHERE column LIKE '%word1%' OR column LIKE '%word2%';

and so on ofcourse. You can use 30000 words if mysql appreciates that..

You can also use this with + instead of whitespaces,.. and with some smart thinking you can use more symbols, like -, &, * etc to expand the search.

[madsm]

omg... mine didn't work because of one missing ' .... 🙂

well thanx anyway!