Question On String Comparison In SELECT Statements

question on string comparison in SELECT statements

--------------------------------------------------------------------------------

First off, this is not the standard problem that can be solved by using:

SELECT * FROM table WHERE string LIKE '%abcd%'

It's actually sort of the opposite of that. I'm looking for a query that can take a string variable and will return only rows where the complete string in the relevant column is a string of the variable passed to the query. So for instance, if the variable passed was 'abcd' then...

rows containing only these strings in the relevant column would be returned:

'abcd'

rows containing these strings in the relevant column would NOT be returned:
'abcdefg'
'abcdxyz'
'abcd1234'
'abcde'
'af'
'hijk'

Is there a way to do this with a MySQL query?

Thanks in advance.