在Drupal视图中“喜欢”模式搜索

Question

I want to use like pattern search in Drupal View query.
Is it possible by using contextual filter?
To make it more clear, lets say search value is "test".

Default search query is where:

WHERE (( (field_data_field_design_code.field_design_code_value = 'test') )
AND(( (node.status = '1')

I want it like:

WHERE (( (field_data_field_design_code.field_design_code_value like '%"tes"%') )
AND(( (node.status = '1')

Any help would be appreciated.

Answer 1

You can use db_query as below:

db_query('SELECT node.nid, node.title FROM {node}
INNER JOIN field_data_field_design_code ON node.nid = field_data_field_design_code.nid
WHERE field_data_field_design_code.field_design_code_value LIKE \'%%"%s"%\' AND node.status = %d', $keyword, 1);

You need to use %% in db_query to use LIKE, http://drupal.org/node/56400#comment-161218.