gistfile1.sql

SELECT DISTINCT 
  COUNT(*)
FROM
  `SiteTree_Live` 
WHERE (
    MATCH (
      Title,
      MenuTitle,
      Content,
      MetaDescription
    ) AGAINST ('About*' IN BOOLEAN MODE) + MATCH (
      Title,
      MenuTitle,
      Content,
      MetaDescription
    ) AGAINST ('About*' IN BOOLEAN MODE) 
    AND ShowInSearch <> 0
  )

Export of row I am trying to match:

INSERT INTO `SiteTree_Live` (
  `ID`,
  `ClassName`,
  `Created`,
  `LastEdited`,
  `URLSegment`,
  `Title`,
  `MenuTitle`,
  `Content`,
  `MetaDescription`,
  `ExtraMeta`,
  `ShowInMenus`,
  `ShowInSearch`,
  `Sort`,
  `HasBrokenFile`,
  `HasBrokenLink`,
  `ReportClass`,
  `CanViewType`,
  `CanEditType`,
  `Version`,
  `ParentID`,
  `Priority`
) 
VALUES
  (
    '2',
    'Page',
    '2014-03-20 10:01:02',
    '2014-03-20 10:01:02',
    'about-us',
    'About Us',
    NULL,
    '<p>You can fill this page out with your own content, or delete it and create your own pages.<br /></p>',
    NULL,
    NULL,
    '1',
    '1',
    '2',
    '0',
    '0',
    NULL,
    'Inherit',
    'Inherit',
    '1',
    '0',
    NULL
  ) ;