[Koha] database help needed

[Magnus Enger]

Hi!

A hint on how to use MySQL to get the data out of the marcxml can be
found here:
http://wiki.koha.org/doku.php?id=sql_library#query_marc

Regards,
Magnus Enger
libriotech.no

2010/4/8 Koustubha Kale <kmkale at anantcorp.com>:
> Dear Vimal,
> It will be in the marcxml field in the biblioitems table. You will have to
> get the longtext which is in xml and filter out your tag 650-a from it.
>
> Regards,
> Koustubha Kale
> Anant Corporation
>
> Contact Details :
> Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka,
> Thane (w),
>         Maharashtra, India, Pin : 400601.
> TeleFax  : +91-22-21720108, +91-22-21720109
> Mobile     : +919820715876
> Website  : http://www.anantcorp.com
> Blog : http://www.anantcorp.com/blog/?author=2
>
>
> 2010/4/8 Vimal Kumar <vimal0212 at gmail.com>
>>
>> Dear Friends,
>>
>> In which table "subject-topic" (650-a) store for Koha?
>>
>> --
>> Vimal Kumar V.
>> Asst. Librarian
>> Asian School of Business
>> Technopark, Trivandrum-695 581
>> Web: www.vimalkumar.co.nr
>> Blog: http://vimalkumar.oksociety.in
>>
>> OK Society Volunteer. http://oksociety.in
>>
>> ---------------------------------------------------------------------------
>> "I forget what I was taught. I only remember what I have learnt"
>> -Patrick White
>>
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>