# Corregir las comillas después de la importación de phpBB

**URL:** <https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133>\
**Category:** Product Support\
**Created:** [27 Enero, 2018 01:39 UTC](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133 "2018-01-27T01:39:46Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**Author:** ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)\
**Post date:** [27 Enero, 2018 06:13 UTC](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133/16 "2018-01-27T06:13:27Z")

</div>

Found what I was looking for. POSIX regex is a bit different from LIKE or SIMILAR TO.but it allows for more finely tuned pattern matching. The result should be the same as the 12152 query

```plaintext
SELECT COUNT(DISTINCT(id)) 
FROM posts 
WHERE cooked ~* '\[quote' 

```

---

_[View the full topic](https://meta.discourse.org/t/fix-quotes-after-phpbb-import/79133)._