All pastes #2056950 Raw Edit

Stuff

public sql v1 · immutable
#2056950 ·published 2011-05-11 18:28 UTC
rendered paste body
mysql> select marc,marcxml from biblioitems where isbn like '%748662529%';+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| marc                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | marcxml                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| 00982cam a2200301 a 4500001001300000003001100013005001700024008004100041020001500082020002800097020003500125040002200160082000600182100002400188245006500212246003800277260005000315300002100365440003800386500008400424650003900508655002800547852003300575852001900608852002600627942001200653999001500665000026588191CaOOAMICUS20110420154814.0010926r20011998stk           000 1 eng d  a0748662529  a0748662529 (trade pbk.)  a1400034779 (Anchor trade pbk.)  aCaNSHbengcCaHRL1 aF1 aMcCall Smith, R. A.14aThe no.1 ladies' detective agency /cAlexander McCall Smith.3 aNumber 1 Ladies' Detective Agency  aEdinburgh, Scotland :bPolygon,c2001, c1998.  a226 p. ;c22 cm. 4aThe No.1 ladies' detective agency  a"One of the International Books of the Year, Times Literary Supplement"--Cover. 0aWomen detectiveszAfricavFiction. 7aMystery fiction.2gsafd  aCaNSHhFICTION MCCzILL: yes  aCaOWzILL: yes  aCaPChF MCCzILL: yes  2ddccBK  c2788d2788 | <?xml version="1.0" encoding="UTF-8"?><record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim">  <leader>00982cam a2200301 a 4500</leader>  <controlfield tag="001">000026588191</controlfield>  <controlfield tag="003">CaOOAMICUS</controlfield>  <controlfield tag="005">20110420154814.0</controlfield>  <controlfield tag="008">010926r20011998stk           000 1 eng d</controlfield>  <datafield tag="020" ind1=" " ind2=" ">    <subfield code="a">0748662529</subfield>  </datafield>  <datafield tag="020" ind1=" " ind2=" ">    <subfield code="a">0748662529 (trade pbk.)</subfield>  </datafield>  <datafield tag="020" ind1=" " ind2=" ">    <subfield code="a">1400034779 (Anchor trade pbk.)</subfield>  </datafield>  <datafield tag="040" ind1=" " ind2=" ">    <subfield code="a">CaNSH</subfield>    <subfield code="b">eng</subfield>    <subfield code="c">CaHRL</subfield>  </datafield>  <datafield tag="082" ind1="1" ind2=" ">    <subfield code="a">F</subfield>  </datafield>  <datafield tag="100" ind1="1" ind2=" ">    <subfield code="a">McCall Smith, R. A.</subfield>  </datafield>  <datafield tag="245" ind1="1" ind2="4">    <subfield code="a">The no.1 ladies' detective agency /</subfield>    <subfield code="c">Alexander McCall Smith.</subfield>  </datafield>  <datafield tag="246" ind1="3" ind2=" ">    <subfield code="a">Number 1 Ladies' Detective Agency</subfield>  </datafield>  <datafield tag="260" ind1=" " ind2=" ">    <subfield code="a">Edinburgh, Scotland :</subfield>    <subfield code="b">Polygon,</subfield>    <subfield code="c">2001, c1998.</subfield>  </datafield>  <datafield tag="300" ind1=" " ind2=" ">    <subfield code="a">226 p. ;</subfield>    <subfield code="c">22 cm.</subfield>  </datafield>  <datafield tag="440" ind1=" " ind2="4">    <subfield code="a">The No.1 ladies' detective agency</subfield>  </datafield>  <datafield tag="500" ind1=" " ind2=" ">    <subfield code="a">"One of the International Books of the Year, Times Literary Supplement"--Cover.</subfield>  </datafield>  <datafield tag="650" ind1=" " ind2="0">    <subfield code="a">Women detectives</subfield>    <subfield code="z">Africa</subfield>    <subfield code="v">Fiction.</subfield>  </datafield>  <datafield tag="655" ind1=" " ind2="7">    <subfield code="a">Mystery fiction.</subfield>    <subfield code="2">gsafd</subfield>  </datafield>  <datafield tag="852" ind1=" " ind2=" ">    <subfield code="a">CaNSH</subfield>    <subfield code="h">FICTION MCC</subfield>    <subfield code="z">ILL: yes</subfield>  </datafield>  <datafield tag="852" ind1=" " ind2=" ">    <subfield code="a">CaOW</subfield>    <subfield code="z">ILL: yes</subfield>  </datafield>  <datafield tag="852" ind1=" " ind2=" ">    <subfield code="a">CaPC</subfield>    <subfield code="h">F MCC</subfield>    <subfield code="z">ILL: yes</subfield>  </datafield>  <datafield tag="942" ind1=" " ind2=" ">    <subfield code="2">ddc</subfield>    <subfield code="c">BK</subfield>  </datafield>  <datafield tag="999" ind1=" " ind2=" ">    <subfield code="c">2788</subfield>    <subfield code="d">2788</subfield>  </datafield></record> |+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1 row in set (0.13 sec)