SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
On 22 November 2012 15:01, Neil Tompkins neil.tompk...@googlemail.com wrote:
Michael,
Thanks this kind of works if I'm checking two types. But what about if I
have 5 types ?
On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman
HAVING listid = 'x,y,z';
On 22 November 2012 15:10, Ben Mildren ben.mild...@gmail.com wrote:
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
On 22 November 2012 15:01, Neil Tompkins neil.tompk...@googlemail.com wrote:
Michael,
Thanks this kind of works if I'm checking two types
*HAVING typelist = 'x,y,z';
On 22 November 2012 15:25, Ben Mildren ben.mild...@gmail.com wrote:
Ah read it quickly and misread your requirement. Joins are likely FTW
here. The alternative would be to do something like this, but I'd opt
for the joins if you have a reasonably sized data set
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost