What is the MySQL query equivalent of PHP strip_tags?

by

MySQL >= 5.5 provides XML functions to solve your issue:

SELECT ExtractValue(field, '//text()') FROM table;

Reference: https://dev.mysql.com/doc/refman/5.5/en/xml-functions.html

More Related Contents:

  1. How to use IN & NOT IN same query [closed]
  2. MySQL: Large VARCHAR vs. TEXT?
  3. MySQL: is a SELECT statement case sensitive?
  4. Check overlap of date ranges in MySQL
  5. 1114 (HY000): The table is full
  6. UPDATE multiple tables in MySQL using LEFT JOIN
  7. How to raise an error within a MySQL function
  8. Multiple-column foreign key in MySQL?
  9. What is maximum query size for mysql?
  10. Finding all parents in mysql table with single query (Recursive Query)
  11. Get the latest date from grouped MySQL data
  12. How to execute a MySQL command from a shell script?
  13. UUID performance in MySQL?
  14. Select most common value from a field in MySQL
  15. MySQL: NULL vs “”
  16. MySQL update a joined table
  17. Returning the ‘last’ row of each ‘group by’ in MySQL
  18. Optimal MySQL settings for queries that deliver large amounts of data?
  19. mysql configuration stops at “starting server”
  20. What is the best way to delete old rows from MySQL on a rolling basis?
  21. Is it possible to reference one column as multiple foreign keys?
  22. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  23. mysql equivalent data types
  24. Get difference in years between two dates in MySQL as an integer
  25. How to Import Multiple csv files into a MySQL Database
  26. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  27. Split a string and loop through values in MySQL stored procedure
  28. Create an index on a huge MySQL production table without table locking
  29. MySQL concurrency, how does it work and do I need to handle it in my application
  30. mysql select id and name from other table and join query

Leave a Comment