Trouble: Can't search data with a "+" on the end..

[bostonmacosx]

I'm search a column where one of the VARCHAR data points is '75+'

When I run

SELECT * FROM `population` WHERE demographic = "75+"

I get no responses back although I know that they are in there.

What gives?

[NogDog]

Are you sure there are no spaces in the data (perhaps after the "+")? To check, you could try something like:

SELECT * FROM `population` WHERE demographic LIKE '%75+%'

Or you could trim the value:

SELECT * FORM `population` WHERE TRIM(`demographic`) = '75+'