search query selection?

I am trying to customize my Mediawiki Seach in $_server['PHP_SELF']. I would like to ask your help. I use mediawiki 1.18, wamp server, mysql.
I can index pages list like this Code:

select page_title from page where page_namespace = 0;
But i like it for search query. I tried like this to search only Main_ns' page title but not work
PHP Code:
query = "SELECT 'page_title' FROM page WHERE 'page_namespace = 0' AND 'page_title' like '%page title%'";


thanks in advance

 

You have pages whose title has "page title" in the title? That's what your query is looking for.

 

Now it worked like this
$query = "SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE '%$keyword%'";

 

BIG difference. If you

$query = "SELECT 'page_title' FROM page WHERE 'page_namespace = 0' AND 'page_title' like '%page title%'";  
echo $query.'<br />';
$query = "SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE '%$keyword%'";
echo $query;
exit;

PHP:

you'll see why the first one didn't work.