我如何使用PHP从MySQL中收集垂直线

Question

If have following problem. I cannot get values from MySQL when I have them separated with |

I have following string:

SELECT * FROM user WHERE CONCAT(',', category, ',') REGEXP ',(lc_8|swimming),'

and this string only works when in my MySQL I have column category with value lc_8,swimming,

How I can change string above to get same values but if in column I have lc_8|swimming|?

Answer 1

| is a special character in regexps. You would need to escape it, like \|. Try:

SELECT * FROM user WHERE CONCAT(',', category, ',') REGEXP ',(lc_8\|swimming),'

Characters that need escaping in regexes are as follows:

* ? + [ ( ) { } ^ $ | \

If you really want to match the parentheses in your example, you would need to quote them as well.