vendredi 28 avril 2017

MySQL Query doesn't check for condition

I have a query like this:

 select * from `research_purchases` left join `company_research_articles` on `research_purchases`.`researchable_id` = `company_research_articles`.`id` and `research_purchases`.`researchable_type` = 'Modules\Analystsweb\Entities\CompanyResearchArticle'

The research_purchases table structure is like this:research_purchases table

It is not filtering the "Modules\Analystsweb\Entities\CompanyResearchArticle" part and giving me the entire result. Any suggestions would be appreciated. Thank you.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire