mysql query to find html tag element in database

Question

I want to query html in mysql i.e. I have record in table say x with info feild value y . How can I query to match if y is present in that table .

select * from x where info="<p>y</p>";

is it only possible with full-text search or is there any other method too.

What are you mean with full-text search? Is info like "%y%" what you searching for? — Jens
– Jens, Commented Jul 20, 2014 at 8:28
If that's the whole field value, why doesn't info="y" work for you? — Barmar
– Barmar, Commented Jul 20, 2014 at 8:43
info="y" works only using mysql query but when using with php it does not work. — user3614990
– user3614990, Commented Jul 21, 2014 at 9:39

Leeft · Accepted Answer · 2014-07-20 09:16:02Z

1

SELECT * FROM x WHERE info LIKE '%y%'; is the only thing you can do to match such a string. Full-text search indexes work quite differently and are not suitable for the task. But this LIKE statement is very inefficient: it has to scan every matching row.

answered Jul 20, 2014 at 9:16

Leeft

3,8371 gold badge19 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

mysql query to find html tag element in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related