The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End mySQL How to INNER JOIN with IDs like this ["1","2"]

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
  • #171700

    Hello everyone,

    I’m stumped, I’m working on a custom Joomla extension, its saving a set of foreign keys into my table’s column like this [“1″,”2″,”3”] they are wrapped with the brackets, how do I do a join to look up their titles by ID when they are saved like that, currently I don’t think mysql sees that column’s content as IDs because of the brackets?

    Here is my query:
    ‘SELECT p.*, c.title AS category FROM xszfo_products_pianos AS p’
    INNER JOIN xszfo_categories AS c ON (p.catid =
    INNER JOIN xszfo_products_finishes AS f ON (p.finish =
    WHERE = ‘1’

    Please, if you could point me the right direction I would be so grateful!

Viewing 1 post (of 1 total)
  • The forum ‘Back End’ is closed to new topics and replies.