Mysql : Select query with like

Question

I have this kind of data in my database "mydb" :

id | name
---------
1  | abcdef
2  | bcdefg
3  | cdefgh
4  | defghi
5  | efghij

I do a simple SELECT query like this one :

SELECT * FROM mydb WHERE name LIKE '%defgh%'

So i get those results :

id | name
---------
3  | cdefgh
4  | defghi

I would like to know if there is a way, with mysql, to inject html code which encompasses the string searched with "LIKE" statement directly in the result ?

So the results would be :

id | name   | html
----------------
3  | cdefgh | c<mark>defgh</mark>
4  | defghi | <mark>defgh</mark>i

replace(name, 'defgh', '<mark>defgh</mark>')

Stu
– Stu

2023-08-22 14:34:26 +00:00
Commented Aug 22, 2023 at 14:34 — Stu
– Stu, Commented Aug 22, 2023 at 14:34

Loïc · Accepted Answer · 2023-08-22 14:33:57Z

0

Sure, something like this should do :

SELECT id, name, replace(name, 'defgh', '<mark>defgh</mark>') as html
  FROM mydb 
  WHERE name LIKE '%defgh%'

answered Aug 22, 2023 at 14:33

Loïc

12k2 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aurélien Grimpard Over a year ago

Ah yes that will do ! But i use PDO prepared query ... i should have mention it. I think it will be better to do another question ...

Aurélien Grimpard Over a year ago

Here is the other question : stackoverflow.com/questions/76954518/…

Collectives™ on Stack Overflow

Mysql : Select query with like

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related