syntax for strings in REQUIRE ISSUER / REQUIRE SUBJECT

I cannot seem to get SSL connections working using the REQUIRE ISSUER or REQUIRE SUBJECT clauses. I have a mysql working with ssl. I can connect from the client host to the server using ssl, where the user has been setup using: GRANT ALL PRIVILEGES ON x.* TO ''@'ipaddress' IDENTIFIED

Re: Need help with query

Hi! I think that the query that you have proposed is the best possible for the problem. However, if there are duplicates in the orders table, then HAVING COUNT(item_id) = 4 should be replaced with HAVING COUNT(DISTINCT item_id) = 4 (I assume that you meant item_id and not org_id in the