Posted By

nielsenrc on 09/20/11


mysql cmsms

Versions (?)

CMS Made Simple Query for Pages Containing '#'

 / Published in: MySQL

Get all page names and ids from the DB of pages with content containing '#'

  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  

You need to login to post a comment.