Hello There,
I'm having a problem thinking of a solution for a program I'm attempting to develop. What I would like to do is select some rows from my MySQL database and avoid selecting others at the same time. Let's say I have rows 1,3,5 and 7. If I did the usual SELECT * FROM table I would get all of them but what I would want to do is use a query like SELECT * from table EXCEPT where username='You' and username='That', is there any such thing or am I totally going the wrong way about this?
Thanks in Advance.
Azhar A. Jassal.
I'm having a problem thinking of a solution for a program I'm attempting to develop. What I would like to do is select some rows from my MySQL database and avoid selecting others at the same time. Let's say I have rows 1,3,5 and 7. If I did the usual SELECT * FROM table I would get all of them but what I would want to do is use a query like SELECT * from table EXCEPT where username='You' and username='That', is there any such thing or am I totally going the wrong way about this?
Thanks in Advance.
Azhar A. Jassal.