mySQL substring & instr problem

Question

Anyone able to have at look at this? still un-resolved and am desperate to get this working, I am confident I know how the code is working, it is just a problem with the WHERE clause.

I need it so that the var $pageGrandChild matches the last part of a string in the database i.e. foo-bar-rules. Any ideas?

$pageGrandChild = PAGEGRANDCHILD;
$rangeRelationResult = mysql_query("SELECT DISTINCT SUBSTRING(slug, 1, INSTR(slug, '-') - 1) result
                                    FROM web_navbar_links
                                    WHERE SUBSTRING(slug FROM INSTR(slug, '".PAGECHILD."') + 2) = '$pageGrandChild'
                                    AND grandchild = 1
                                    AND slug != '".PAGEPARENT."-".PAGECHILD."-".PAGEGRANDCHILD."'
                                   ");

Thank you for reading and sorry I have posted this twice.

Please don't post duplicates, they are very much frowned upon around here. I'll post a comment in the other question — Pekka
– Pekka, Commented Oct 25, 2010 at 10:01
possible duplicate of Slight problem getting mySQL SUBSTRING to work.. — Pekka
– Pekka, Commented Oct 25, 2010 at 10:01

MatTheCat · Accepted Answer · 2010-10-25 10:02:26Z

1

<?php mysql_query('...WHERE foo-bar-rules LIKE "%'.$pageGrandChild.'"...'); ?>

?

answered Oct 25, 2010 at 10:02

MatTheCat

18.8k6 gold badges59 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

mySQL substring & instr problem

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related