MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL
);

INSERT INTO `images` (`id`, `product_id`, `url`) VALUES
(1, 8, 'url-8.1'),
(8, 10, 'url-8.11'),
(9, 10, 'url-8.000');



CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL
);

INSERT INTO `products` (`id`, `title`) VALUES
(8, 'Bbetter Vitamin'),
(9, 'Liveasy Essentials'),
(10, 'Horlicks Health');


ALTER TABLE `images`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);
SELECT p.*,ph.url
FROM  products AS p
LEFT JOIN images AS ph 
ON p.id=ph.product_id 
WHERE (p.title LIKE '%hor%')
GROUP BY p.id

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiddle.ph.url' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


SELECT p.*, MIN(ph.id) as iid
FROM products AS p
LEFT JOIN images AS ph
ON p.id=ph.product_id 
WHERE (p.title LIKE '%hor%')
GROUP BY p.id


id
title
iid


10
Horlicks Health
8


SELECT p.*, MIN(ph.url)
FROM products AS p
LEFT JOIN images AS ph
ON p.id=ph.product_id 
WHERE (p.title LIKE '%hor%')
GROUP BY p.id


id
title
MIN(ph.url)


10
Horlicks Health
url-8.000


SELECT p.*, ph.url
FROM products AS p
LEFT JOIN images AS ph
ON p.id=ph.product_id 
WHERE (p.title LIKE '%hor%')
limit 1


id
title
url


10
Horlicks Health
url-8.000


SELECT p.*, ph.url
FROM products AS p
LEFT JOIN images AS ph
ON p.id=ph.product_id 
WHERE (p.title LIKE '%hor%')
order by ph.id asc
limit 1


id
title
url


10
Horlicks Health
url-8.11