Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 10th, 2012  |  syntax: None  |  size: 0.37 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Keywords Table - Need to Format Results, Loop, Count Occurances
  2. SELECT
  3. IF(spaces>1,TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(title,' ',3),' ',-1)),'') as a1,
  4. IF(spaces>2,TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(title,' ',4),' ',-1)),'') as a2,
  5. ... IF(spaces>13,TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(title,' ',15),' ',-1)),'') as a13
  6. FROM `topics` ORDER BY upload_date DESC LIMIT 0,200
create a new version of this paste RAW Paste Data