Home>
help to display the data, here's the query I'm using
SELECT g.`name_ru-RU` as nameship,
(SELECT COUNT (c.id)
FROM `crm` c
WHERE c.`dostavka` LIKE '% g.`name_ru-RU`%'
) as totalcrm
FROM shipping g
the error occurs in this place
LIKE '% g.`name_ru-RU`%')
if I remove g.`name_ru-RU and insert the text, then everything is fine, but I need him to search for this column
thanks, forgot about him altogether)
GENESIS2022-01-11 08:26:02Better WHERE LOCATE (g.name_ru-RU, c.dostavka) or WHERE INSTR (c.dostavka, g.name_ru-RU). Why an extra function call?
Akina2022-01-11 08:27:23Related questions
- php : DB information is not displayed. mysqli. request for a random withdrawal
- php : INSERT query fails in mysqli
- python : pymysql.err.operationalerror: (1305, 'Function Name. Top Does Not Exist')
- mysql : SQL query returns only 1 result
- mysql : Very slow Update Where Order by MariaDB on a secondary key
- Connect repository with the latest version of MySQL (8) for Ubuntu 16.04?
- How to send all selected SELECT OPTION VALUE PHP MYSQL values?
- php : How to convert an array with the same keys to an associative, keeping all the values?
- mysql : Do not see a column
- php : Not added entries in the database
like concat ('%', g.name_ru-RU, '%')
splash582022-01-11 08:21:05