Untitled query #6828

SQL

USE lvwiki_p;
SELECT LOCATE (p2.page_title, p1.page_title)#p1.page_title, p2.page_title
FROM page as p1
join page as p2 on p1.page_namespace = p2.page_namespace
WHERE p1.page_title="Edgars2007/AWB" and #p1.page_title like "p1.page_title"

LOCATE (p2.page_title, p1.page_title)
#ISNULL( LOCATE (p2.page_title, p1.page_title),0) = 0

#p2.page_title LIKE CONCAT(p1.page_title,"s")

#exists (p2.page_title from page as p2 where p2.page_title=CONCAT(p1.page_title,"s") and )
and p1.page_namespace=2 and p1.page_is_redirect=0
AND p2.page_namespace=2 and p2.page_is_redirect=0
SQL

Checking query status...
