# Full-text query troubles

**URL:** https://forum.kirupa.com/t/full-text-query-troubles/232162
**Category:** programming
**Created:** [July 11, 2007, 4:45pm UTC](https://forum.kirupa.com/t/full-text-query-troubles/232162 "2007-07-11T16:45:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)
#### Post date: [July 11, 2007, 4:45pm UTC](https://forum.kirupa.com/t/full-text-query-troubles/232162/1 "2007-07-11T16:45:45Z")

</div>

I’m trying to just test a query in phpmyadmin before putting into a php script but it is giving me a generic error message and not really helping me, i have tried every possible combination of quotes, still no luck.

I have created a fulltext index and it is correctly built.

the sql statement:

```auto
SELECT * MATCH(element1_en) AGAINST ('oxford') AS score FROM AATimeline_pages WHERE MATCH(element1_en) AGAINST ('oxford') ORDER BY score DESC

```

it’s giving me the 'ole:

> #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL blah blah blah…

Any ideas where i might be going wrong?