syntax error

[mystrymaster]

I have this query

SELECT middlesex.*, garage.ID AS GID
FROM middlesex, garage
WHERE garage.num, 
LIKE  '%middlesex.Prime%'

and I have used the like function in other queries but this is the error returned by phpMyAdmin

#1064 - You have an error in your SQL syntax near '
LIKE '%middlesex.Prime%' LIMIT 0, 30' at line 3

I have tried even changing the original middlesex.* to middlesex.Prime which is a valid field in the db and have also tried adding the garage.num from the where clause to the select statement and nothing.

[jayant]

WHERE garage.num,
LIKE '%middlesex.Prime%'

you have a comma (,) at end of WHERE... line.

[mystrymaster]

:smacks self in the head repeatedly with ball pean hammer:

[jayant]

Originally posted by mystrymaster