title: How to search exact string using MySql Query which avoids extended values?
body: <p>My Query looks like</p>
  
  <pre><code>$search_query = db_query("SELECT nd.nid, users.name, nd.type FROM node as nd 
  LEFT JOIN node_revisions as nd_rev ON nd_rev.nid = nd.nid AND nd_rev.vid = nd.vid 
  LEFT JOIN users ON nd.uid = users.uid 
  WHERE nd.status = 1 AND nd_rev.body LIKE LOWER('%node/100%') 
  AND nd.nid NOT IN(SELECT DISTINCT nid FROM term_node WHERE tid = 293)");
  </code></pre>
  
  <p>This query actually returns all the matches from node_revisions.body field, Which includes
  node/1000, node/1001.... Etc.,</p>
  
  <p>I want to get only the result of exact match where possible like</p>
  
  <pre><code>"node/100"
  "node/100/"
  "/node/100"
  "/node/100/"
  'node/100'
  'node/100/'
  '/node/100'
  '/node/100/'
  </code></pre>
  
  <p>and not like</p>
  
  <pre><code>"node/1006"
  "node/10064/"
  "/node/1000"
  "/node/10001/"
  'node/10023'
  'node/1005/'
  '/node/1001'
  '/node/10069/'
  </code></pre>
  
  <p>This above query returned me result which has string like below..
     ..a href="/node/1006"</p>
  
  <p>How to avoid this kind of errors? Please help..</p>