Hello, I am wondering if it is possible to select rows where, the where statement includes two of the same operator or something.. Im no good at explaning but this would be the best way to show you what I mean:
SELECT DISTINCT `USER_ID2` WHERE `USER_ID` = '1' AND `USER_ID` = '4';
and that would show all the fields where the user_id = 1 and 4... :-\
user_id will never be equal to 4 when it is equal to 1 and never equal to 1 when it is equal to 4 since a single field can only have one value at a time. You probably mean OR rather than AND as using OR will return records where it is equal to 1 as well as records where it is equal to 4.
SELECT * FROM `friends` WHERE `user_id` = '1' OR `user_id` = '4