SQL query doesn't work's

Question

I have used this query but it doesn't work's with my data, i have attached the snapshot of data in my database as well.

MYSQL Query is as follow's:

SELECT * FROM hotPropertyAlert WHERE FIND_IN_SET('E2', locations) AND ( 'parking' = 'H' )

Once the query is executed didn't return's the result.

Thank's in advance...

What are you trying to achieve – jonju Aug 04 '16 at 18:26 — jonju, Aug 04 '16 at 18:26
never bothered checking for errors. – Funk Forty Niner Aug 04 '16 at 18:35 — Funk Forty Niner, Aug 04 '16 at 18:35

score 2 · Accepted Answer · answered Aug 04 '16 at 18:26

2

Parking, being a column name, should not be quoted:

SELECT * FROM hotPropertyAlert WHERE FIND_IN_SET('E2', locations) AND ( parking = 'H' )

answered Aug 04 '16 at 18:26

aynber

score 0 · Answer 2 · answered Aug 04 '16 at 18:28

0

Find_in_set return the index of the searche string so you should check if find_in_set is > 0

 SELECT * 
 FROM hotPropertyAlert 
 WHERE FIND_IN_SET('E2', locations) > 0 AND ( parking = 'H' )

answered Aug 04 '16 at 18:28

ScaisEdge

Comparing to 0 isn't necessary: http://stackoverflow.com/questions/22480418/mysql-request-from-empty-column-and-find-in-set – aynber Aug 04 '16 at 18:30
I don't compare if is equal to zero .. but if is greater . .. this mean that the string is in set – ScaisEdge Aug 04 '16 at 18:32

2 Answers2