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 '???' Code (markup): What shall i put as my comparison parameter?
Do you want to find all the fields that contain these characters as a substring? Then you would write LIKE '%your_substring%';