select value,
replace(value, char(0x00B6 using utf8), '\r\n') as new_value_1,
replace(value, char(0xB6 using utf8), '\r\n') as new_value_2
from oc_setting
where value like concat('%', char(0xB6 using utf8), '%')
or value like concat('%', char(0x00B6 using utf8), '%')
select ASCII('¶')
select value,
replace(value, char(ASCII('¶')), '\r\n') as new_value,
ASCII('¶') as search_code_symbol
from oc_setting
where value like concat('%', char(ASCII('¶')), '%')
select value,
replace(replace(value, char(0xB6 using utf8), '\r\n'), char(0x00B6 using utf8), '\r\n') as new_value
from oc_setting
where value like concat('%', char(0xB6 using utf8), '%')
or value like concat('%', char(0x00B6 using utf8), '%')
select *
from oc_setting
where value like concat('%', char(182), '%')
-- value like concat('%', char(1987), '%')
-- value like concat('%', char(0xB6), '%')
-- value like concat('%', char(0x00B6), '%')
-- value like concat('%', char(0xB6 using utf8), '%')
-- value like concat('%', char(0x00B6 using utf8), '%')
SELECT value,
replace(replace(replace(value, char(0x0A using utf8), '\\n'), char(0xc2b6 using utf8), '\\r\\n'), char(0x0D using utf8), '\\r') AS new_value
FROM table_name
update table_name
set value = replace(replace(replace(value, char(0x0A using utf8), '\n'), char(0xc2b6 using utf8), '\r\n'), char(0x0D using utf8), '\r')
SELECT value,
replace(replace(replace(value, char(0x0A using utf8), '\n'), char(0xc2b6 using utf8), '\r\n'), char(0x0D using utf8), '\r') AS new_value
FROM table_name
SELECT value,
replace(replace(replace(value, char(0x0A using utf8), '\\n'), char(0xc2b6 using utf8), '\\r\\n'), char(0x0D using utf8), '\\r') AS new_value
FROM table_name
Выведите то, что прилетает в POST по ключу service, когда что-то выделено. Обратите внимание на тип данных.
И обратите внимание, как имея этот тип данных, производить обработку в условиях:
if ($service == 1690)