Hello,
I have a simple question (i think )
How do i write a SQL query which will search a column for more than one keyword (like the + on google)
ie. i want to get all the records witch will match name=piet de jong with the keywords jong+piet+de
i thought it is something like this:
$query=SELECT .... FROM ... WHERE name LIKE '%jong%' AND name LIKE '%piet%'
but this does not work
hope somebody can help me!!
bye,
