Having problems with message search?
I'm not certain what the syntax with OpenOffice is, but try something like:
select *
from batting
where [3B] like 23
or
select *
from batting
where `3B` like 23
If that fails, try looking at some help screens for sample queries. They will probably clue you in as to how you force the program to recognize a text string as a field name and not to interpret it as something else.
Bryan
On 5/3/09, moose <st_moose@...> wrote:
Is anyone using openoffice with the Lahman database?
I am having issues when I try to make a query with the 2B and 3B data, getting errors that I do not understand...
an example
select *
from batting
where 3B like 23
gives the following error
SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
what am I missing?
thanks
mike
Offline 
Send Email