SQL Query: LIKE

Asked Sep 28 '16 at 15:16

Active Sep 28 '16 at 15:37

Viewed 19 times

I have a query where I want to view names of carparks (cp_name) that are near the iona building (nearbyFacilities). The query works without the last line but it displays all carparks. Any idea how to just get the results related to the word iona?

SELECT CP_Name.Name, CP_Location.nearbyFacilities
FROM CP_Name
INNER JOIN CP_Location 
ON CP_Name.CarparkID = CP_Location.CarparkID 
WHERE nearbyFacilities LIKE `%iona%`  -- this line doesn't work

edited Sep 28 '16 at 15:37

Galma88

2,398
6
29
50

asked Sep 28 '16 at 15:16

sarahjane

`like '%iona%'` – fthiella Sep 28 '16 at 15:17
i had quotes but the site turned into a shaded area – sarahjane Sep 28 '16 at 15:18
See [When to use single quotes, double quotes, and backticks?](http://stackoverflow.com/q/11321491) – eggyal Sep 28 '16 at 15:20
@sarahjane I just tried to edit, and noticed that you had _backticks_, not quotes, around `LIKE`. Use quotes (the key immediately to the right of the semicolon). – Tim Biegeleisen Sep 28 '16 at 15:20
such a simple solution that I missed. Thanks for the help. – sarahjane Sep 28 '16 at 15:22
Happy to help, I think I've seen 3-4 of this type of question today, so it must be a common beginner error. – Tim Biegeleisen Sep 28 '16 at 15:23

SQL Query: LIKE

0 Answers0