How can I find every row in a table where the value of a field is contained in a specific string?

Question

Usually, I use

SELECT * FROM tableName WHERE fieldName LIKE '%string%'

to find every row in tableName where the value of fieldName contains the string 'string'. How can I find every row in tableName where the value of fieldName is contained in the string 'string'?

For example, in the following table

names

FirstName | LastName
Bob       | Dylan
Bob       | Marley

I would like to use the string "Bob Marley" in order to find [Bob | Marley] and [Bob | Dylan], so I would say: Find all rows in names where the value of FirstName is contained in "Bob Marley"

I thought of this:

SELECT * FROM tableName WHERE 'string' LIKE %fieldName%

but it doesn't work.

Answer 1

SELECT * FROM tablename WHERE 'string' like '%' + fieldname + '%'

Answer 2

SELECT  *
FROM    (
        SELECT  'Bob' AS name, 'Marley' AS lastname
        UNION ALL
        SELECT  'Bob' AS name, 'Dylan' AS lastname
        ) q
WHERE   'Bob Marley' LIKE CONCAT('%', name, '%')

Answer 3

Try this:

Select * From tableName where 'string' Like '%' + fieldName + '%'

Answer 4

Try this:

SELECT *
  FROM tableName
 WHERE LOCATE(fieldName, 'string') > 0;

Answer 5

Thanks to Chris Nielsen and mmayo, I found this working solution:

Select * From utilisateur where 'Shawn Freyssonnet-Inder' Like CONCAT('%', Prenom, '%')