SQL help

[Anon]

hi,

i want to create a search page in php.
for this, i want to know how to write a query such that if the user enters two words say A and B, then the query generated should return results such that it should show rows where there is A or B but not A and B;

eg results should be

A C D...
B C ...

but not

A C B...

where A,B,C,D.. are different words entered by the user

thanx

[[deleted]]

try something like

SELECT *
FROM table
WHERE (column LIKE '%A%'
AND column NOT LIKE '%B%')
OR (column LIKE '%B%'
AND column NOT LIKE '%A%')