mysql query - contains?

sql mysql database full-text-search mysql-error-1064
JJunior picture JJunior · Aug 12, 2010 · Viewed 24.9k times · Source

how can i search for a particular string in mysql? I tried using contains- gives me 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

D'Arcy Rittich picture D'Arcy Rittich · Aug 12, 2010

Try 

AND i.description LIKE '% DBK%'

Related questions

Order SQL by strongest LIKE?

I have the following query: SELECT * FROM table_name WHERE (col_1 LIKE '%$keyword%' OR col_2 LIKE '%$keyword%' OR col_3 LIKE '%$keyword%') AND .... <some optional filters> ... is there a strategy to sort based …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More