How to match an alphanumeric string data in a field?

[wonder_gal]

I would like to return a total number of records from a table in which their 'inMessage' field matches the a string with a format like this, eg. "55 213 aaa 58"

Can anyone tell me how shall i write the sql statement?



SELECT COUNT(*) AS Total FROM Inlog WHERE Message LIKE '???'


What shall i put as my comparison parameter?

[Michau]

Do you want to find all the fields that contain these characters as a substring? Then you would write LIKE '%your_substring%';