Using REGEXP in SQL syntax with concatenated PHP variable

Question

I have this table where in it store the score and based on each category. The data store in this format, "_bestscore_category1_user1", the title of the stats, the name of the category, and the user. As you can see they are delimited by underscore.

Table
---------------------------------------- 
User                       | Score
_bestscore_category1_user1 |  10
_bestscore_category1_user2 |  20
_bestscore_category2_user2 |  20
_bestscore_category2_user1 |  5

So the problem is that, Im trying to query the field based on the user, my sql statement is like this.

SELECT meta_value from wp_postmeta WHERE meta_key REGEXP '_bestscore_([^=])_". $user."'

As you can see we have variable $user which is dynamic, trying this sql, gives me a null output. I wonder if my sql is incorrect, I did try to validate it, but null is the value I'm getting. Any idea?

Note: SQL statement, is not related to the table,

Try changing the regex to _bestscore_([^_]*)_

hwnd
– hwnd

2014-11-21 04:17:51 +00:00
Commented Nov 21, 2014 at 4:17 — hwnd
– hwnd, Commented Nov 21, 2014 at 4:17

Yash · Accepted Answer · 2014-12-06 07:35:06Z

1

Try this:

SELECT meta_value from wp_postmeta WHERE meta_key REGEXP '_bestscore_.*?_". $user."'

this will solve your problem.

answered Dec 6, 2014 at 7:35

Yash

1,4361 gold badge13 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Using REGEXP in SQL syntax with concatenated PHP variable

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