Advanced Search

CMS Made Simple Query for Pages Containing \'#\'

/ Published in: MySQL
Save to your folder(s)
Get all page names and ids from the DB of pages with content containing '#'

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT cms_content.content_id, cms_content.content_alias, cms_content.content_id, cms_content_props.content  FROM cms_content, cms_content_props WHERE cms_content.content_id = cms_content_props.content_id AND cms_content_props.content LIKE '%#%';

Report this snippet


Comments

You need to login to view comments.