Mysql query - contains?

Question

How can I find a specific row in mysql? I tried using contains- gives me an error:

SELECT r.name , r.network , r.namestring , i.name , r.rid , i.id , d.dtime , d.ifInOctets , d.description FROM router AS r INNER JOIN interface AS i ON r.rid = i.rid INNER JOIN 1278993600_1_60 AS d ON i.id = d.id AND d.dtime BETWEEN 1279027200 AND 1279029000 WHERE r.network = "ITPN" AND i.status = "active" AND i.description CONTAINS ' DBK' 

Please, help.

Answer 1

Try

 AND i.description LIKE '% DBK%' 

Answer 2

Search LIKE :

 AND i.description LIKE '% DBK%' 

Additional Information:

• http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
• http://www.htmlite.com/mysql011.php

Answer 3

use as e.g. AND i.description LIKE '% DBK%'

Answer 4

Try

 ...AND i.description like '% DBK%' 

Or

 ...AND upper(i.description) like '% DBK%' 

If you want to get something with DBK , DBK , DBK , DBK , ...