I want to use php function in SQL query,

Question

I want to use str_replace() in SQL query,

db_query('SELECT * FROM {node} n INNER JOIN {accesslog} a ON n.nid = str_replace("node/", "", a.path);

but still not work. please help.

thank you.

Ignacio Vazquez-Abrams · Accepted Answer · 2010-12-05 03:02:56Z

6

Pick a function that the SQL engine does know, such as REPLACE().

answered Dec 5, 2010 at 3:02

804k160 gold badges1.4k silver badges1.4k bronze badges

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

1 Comment

INNER JOIN {accesslog} a ON n.nid = REPLACE(a.path, "node/", "") do work! thank you!

anon · Accepted Answer · 2010-12-05 03:04:32Z

2

Use MySQL's REPLACE function instead of PHP's str_replace.

answered Dec 5, 2010 at 3:04

anon

INNER JOIN {accesslog} a ON n.nid = REPLACE(a.path, "node/", "") do work! thank you!