[RESOLVED] A MySQL pattern match query....

[listenmirndt]

This is the database the field contains :

51550
(these represent category ID numbers)

So for example, I want to select where like '5'

Or where like '50'

For example...

WHERE LIKE '50' does not seem to work,
and WHERE LIKE '%50%' selects more then just 50

Anyone have an idea how to phrase this?

Thanks!

[EDIT]
Found my own problem, underscores are used for a special function, replaced then with dashes (-) and it worked fine.