Tag: SQL

  • MySQL Optimisation Trick using EXISTS

    One for the geeks I’m afraid. I’m developing a site with quite a complicated menu system getting details using equally complicated database queries. In various places in the menu, I needed to find out whether to display a particular sub-menu. To do this I had some SQL to check whether any products existed at that […]