How to use COALESCE or if else condition in manticore sql query

[Kamleshgeet]

Using MySQL we can below.
But I want to do for manticore SQL query.
If possible for manticore JSON query then I want it too

CREATE TABLE [products1](
	[Id] [int] NOT NULL,
	[standard] [nvarchar](500) NOT NULL,
	[en] [nvarchar](500) NULL,
	[hi] [nvarchar](500) NULL);

INSERT INTO products1(Id, standard, en, hi)
VALUES (1, 'build your own computer nikon', 'build your own computer', null);
INSERT INTO products1(Id, standard, en, hi)

VALUES (2, 'Nikon D5500 DSLR - Black', '', null);

INSERT INTO products1(Id, standard, en, hi)

VALUES (3, 'Nikon D5500 DSLR - Red', '', null);

Using below query I am able to search from products using MySQL

SELECT *
FROM Products1
WHERE COALESCE(en,[standard]) like ‘%nikon%’

OR

SELECT *
FROM products1
WHERE IF(en is null, standard, en) LIKE '%nikon%'

here is result

2	Nikon D5500 DSLR	NULL	NULL
3	Nikon D5500 DSLR - Black	NULL	NULL

[Kamleshgeet]

Also I want it to sort or order by en asc/desc using if else statement for manticore query
MySQL it is working fine
Something like below

SELECT *
FROM products1 order by if en is null or en='' then standard else en asc

Suggest solution for this.