Advertisement
awaiskhalid

Sql issue

Feb 1st, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.65 KB | None | 0 0
  1. SELECT REPLACE( series,  'A/V',  'AV' ) AS series, fnStripTags(
  2. title
  3. ) AS Title, REPLACE( DATE,  'n.d',  'undated' ) AS eventDate, description AS extentAndMedium, CONCAT_WS(  ' ', fnStripTags(
  4. scopecontent0
  5. ), fnStripTags(
  6. scopecontent1
  7. ), fnStripTags(
  8. scopecontent2
  9. ), fnStripTags(
  10. scopecontent3
  11. ), fnStripTags(
  12. scopecontent4
  13. ) ) AS scopeAndContent, CONCAT_WS(  ' | ', fnStripTags(
  14. notes
  15. ), edition, location ) AS generalNote, seealso AS relatedUnitsOfDescription, subject AS subjectAccessPoints, REPLACE( seriescode,  'A/V',  'AV' ) AS seriescode,  'en' AS culture,  'Osler Library' AS repository,  'file' AS levelOfDescription
  16. FROM lac_penfield
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement