How to execute such a request using CIBlockElement::GetList?

Question

MySQL

Good afternoon!
how to execute a similar request using CIBlockElement::GetList?
The main problem is that in the catalog, product models are entered from the main price list of the supplier,
for example, DX NR-6 SR, and in the price list with prices, the same model can be filled in as DXNR-6SR
, there are a lot of similar positions, and the price list is constantly updated, how using The standard bitrisk API can run the following query so that you can search by model name with and without spaces.
For example, there is an entry in the table with NAME = DX NR-6 SR
in the NAME price list, it can be with or without a space

SELECT * FROM tabe_name WHERE REPLACE(NAME, ' ', '') = 'DXNR-6SR' OR NAME = 'DXNR-6SR'

Answer 1

If the names of the nomenclature are not brought to a single format, then I usually use the search index of the search module or imitate it. So the quality of the sample will be higher.
Or add an OR section to the getlist.