MYSQL - query the database where & is in the cell

Question

I have a table with items in my MySQL database.

I am trying to query a string containing "&". The column is a text value and contains the content "TV and Stands".

SELECT * FROM  `items` WHERE  `name` =  'TV & Stands' LIMIT 0 , 30

This returns 0 results, although TV and Racks are clearly in the name column. If I ask for the name of the element without the "&" character, it returns the correct value.

How can I request this data correctly?

Answer 1

=, , . , / , . LIKE instate.

SELECT * FROM  `items` WHERE  `name` LIKE '%TV & Stands%'

Answer 2

, . , like:

SELECT *
FROM `items`
WHERE `name` LIKE 'TV _ Stands'
LIMIT 0 , 30;