Quick Sql Query Help 10.07.08
Hi,
I have a large messy database that I need a query from to select data within mysql.
Essentially, on this website, all content is assigned to a State. All content, with the actually website content and content id number is in one table, the state names and their state_id number is in another table, and a third table united what state_ids with content_ids.
I need to be able to pull all content by state. For example, for state_id = 6, I need to be able to pull all of that states content from the content table, and then be able to export it. I usually know my way around MySQL, but I keep getting errors when trying to do this query:
SELECT ‘Content’.'idContent’ ‘Content_has_States’.'Content_idContent’ ‘Content_has_States’.'States_idStates’
FROM ‘Content’, ‘Content_has_State’
WHERE ‘Content_has_State’.'States_idStates’ =6
AND ‘Content.idContent’ = ‘Content_has_States.idContent’
I will provide MySQL access to the winner, and I will pay immediately using whatever means necessary. I also need this help FAST. If you could help over gchat or AIM that would be a plus.
