MySQL - You have an error in your SQL syntax - Operators

[MichalisDBA]

Hello.

Same error as Oracle #437

The operators below do not work and produce a You have an error in your SQL syntax; check the manual that corresponds to your... error

<
=lt=
<=
=le=
=in=
=out=
=startWith=
=endWith=

[kdhrubo]

Fixed greater than

/film?filter=rental_duration>6

/film?filter=rental_duration=gt=4

[kdhrubo]

Fixed greater than equal to

/film?filter=rental_duration>=6

film?filter=rental_duration=ge=6

[kdhrubo]

Fixed less than

/film?filter=rental_duration=lt=4

/film?filter=rental_duration<4

[kdhrubo]

Fixed less than equal to

/film?filter=rental_duration=le=3

/film?filter=rental_duration<=3

[kdhrubo]

Fixed IN

/film?filter=film_id=in=(1,2,3)

/film?filter=rating=in=(PG,G,NC-17)

[kdhrubo]

Fixed OUT

/film?filter=film_id=out=(1,2,3)

/film?filter=rating=out=(PG,G,NC-17)

[kdhrubo]

FIXED START WITH n END WITH

/film?filter=title=endWith=EASY

/film?filter=title=startWith=BASIC