Search comma seprated or single value

[shakti_1]

I want to search all record from database on multiple(comma separate) keyword like php,mysql or php with like .

mydatabase record

 id    skill
  1    php,java
  2    php
  3    mysql
  4    java,mysql,php

if i search mysqlthen total record should be 2 and search php,java it should be total record should be 3

please help me

[cereal]

In MySQL you can use a fulltext search. Create an index with skill column:

alter table skills add fulltext skillindx(skill);

then you can use queries like this:

select * from skills where match(skill) against('mysql');

There are some limitations that can be bypassed if you properly configure the database server. The MySQL documentation explains everything:

• http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

Bye!

[pritaeas]

You can use FIND_IN_SET(). That would mean if you want to search for php,mysql for example, that you need to split that string and build your query.