Final Year Project SQL problem

DipStick McSwindler

This post has been deleted.

brevity

When using like I'm pretty sure you have to use the % as wildcard either at the start or the end of the word you are searching for.

I'd bring the AND statements above the other logic. Then filter on profession etc

carlmango11

This is just off the top of my head but I think you might need an extra set of brackets around the OR clauses depending on how you want the statement to be interpreted. If I had to guess I'd say what's happening is that as soon as 1 of the 'OR' clauses if matched the rest of the WHERE section is ignored

DipStick McSwindler

This post has been deleted.

jhegarty

try this:

SELECT `Advert_ID`, `User_ID`, `Username` FROM adverts

WHERE ((`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Ceptic' AND `Skill_Level_Needed` LIKE 'Proffessional')

OR (`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Heating' AND `Skill_Level_Needed` LIKE 'Proffessional')

OR (`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Sink' AND `Skill_Level_Needed` LIKE 'Proffessional'))
AND User_ID = '16' AND Location_Country = 'Ireland' AND Location_City = 'Dublin' AND Active = 1

DipStick McSwindler

This post has been deleted.

carlmango11

IrishFeeney92 wrote: »

Guys I got it,A kind gentleman on Stackoverflow pointed out I had the Brackets placed wrong so the emphasis was on the wrong Statements. Heres thecorrect answer

SELECT `Advert_ID`, `User_ID`, `Username` FROM adverts
WHERE (
(`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Ceptic' AND `Skill_Level_Needed` LIKE 'Proffessional')
OR (`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Heating' AND `Skill_Level_Needed` LIKE 'Proffessional')
OR (`Skill_Proffession_Needed` LIKE 'Plumbing' AND `Skill_Area_Needed` LIKE 'Sink' AND `Skill_Level_Needed` LIKE 'Proffessional')
)
AND `User_ID` = '16'
AND `Location_Country` LIKE 'Ireland'
AND `Location_City` LIKE 'Dublin'
AND Active = 1


Thank you all so much for your help I really appreciate it!

That's exactly what I meant

DipStick McSwindler

This post has been deleted.

DipStick McSwindler

This post has been deleted.