Why does not the answer come

Question

There is a database Serials in it the id and name_serial fields are filled with this value.

id name_serial 648 Любовь/Ненависть

I write such a request

 SELECT * FROM `fl_serial` WHERE `name_serial` = 'Любовь/Ненависть'

I get this answer

 MySQL вернула пустой результат (т.е. ноль строк).

why and how to fix it

1. Missed the closing apostrophe 2. there is a feeling that there are end / initial problems in the line.
@DmitriySimushev corrected the quotes simply not copied from the request and what is the end of the initial problems.
WHERE name_serial LIKE 'Любовь/Ненависть' Will output something?

ilyaplot ilyaplot 3.198 one 9 29 · Accepted Answer · 2016-06-14T11:49:48

Use string comparison functions, such as LIKE. Your request will look like this.

 SELECT * FROM `fl_serial` WHERE `name_serial` LIKE 'Любовь/Ненависть'

1 answer 1