want to execute a mysql-query like this:
"SELECT * FROM table WHERE (name LIKE '%peter%' OR name LIKE '%ralph%' OR name LIKE '%mary%') AND id=5"
but i don't know how to concatenate the LIKE-statements correctly... and i found nothing usable in the documentation
any idea?
ok, i got it by myself.. after trying and trying and trying...
here it is:
"SELECT * FROM table WHERE name LIKE '%peter%' OR name LIKE '%ralph%' OR name LIKE '%mary%' "
.. so you just have to write the whole LIKE-statement over and over againg...