Mysql search query

[Melter]

I'm trying to do a page of items between set prices and I either get an error or the search returns every item. This is what I've tried

SELECT * FROM store WHERE searchPrice => 50 OR searchPrice <= 100 ORDER BY searchPrice ASC

Where am I going wrong?

[Rich]

Just change the OR to AND and it should work fine.

[999gi]

Dont know if it matters but I always use >= rather than =>

[Melter]

Okay tried that and I'm still getting syntax errors.

This works

SELECT * FROM store WHERE searchPrice <= 10 ORDER BY searchPrice ASC

And this doesn't

SELECT * FROM store WHERE searchPrice >= 50 AND <= 100 ORDER BY searchPrice ASC

[amcd78]

Sorry, did you say this doesn't work?

SELECT * FROM store WHERE searchPrice >= 50 AND searchPrice <= 100 ORDER BY searchPrice ASC

[Melter]

Doh! I'd taken out the second searchPrice. That's done the trick. Cheers guys.

[ianm]

You're missing the field name in the second comparison -

SELECT * FROM store WHERE searchPrice >= 50 AND <= 100 ORDER BY searchPrice ASC

Should be

SELECT * FROM store WHERE searchPrice >= 50 AND searchPrice <= 100 ORDER BY searchPrice ASC

[MikkyX]

You could also use:

SELECT * FROM store WHERE searchPrice BETWEEN 50 AND 100 ORDER BY searchPrice ASC

It's something like that anyway.