All Questions
1 question
1
vote
1
answer
74
views
Mysqli query with regex to Joomla php syntax
// CODE1 (Mysql (MariaDB 10.8.3) query):
SELECT s.`p_p`, COUNT(REGEXP_SUBSTR(r.`xml`, '[0-9]+'))
FROM `#__s` AS s, `#__p` AS x, `#__v` AS r
WHERE REGEXP_SUBSTR(r.`xml`, '[0-9]+') = [user_id] AND s.`...