<div>
LIKE '%Operator%' instead of = Operator<br />
<br />
The '%' stands for any number of characters, 0+<br />
You can have the % at the start, at the end, both or not at all (which would make it the same as =)
</div>


LIKE '%Operator%' instead of = Operator

The '%' stands for any number of characters, 0+
You can have the % at the start, at the end, both or not at all (which would make it the same as =)

<div>
Sorry this might be clearer:<br />
<br />
LIKE '%text%' instead of = 'text'<br />
<br />
The '%' stands for any number of characters, zero or more<br />
You can have the % at the start, at the end, both or not at all (which would make it the same as =)<br />
<br />
You might want to take into account case sensitivity as well by using UPPER() or LOWER() on both sides of the operator.<br />
<br />
e.g. UPPER('%text%')
</div>


Sorry this might be clearer:

LIKE '%text%' instead of = 'text'

The '%' stands for any number of characters, zero or more
You can have the % at the start, at the end, both or not at all (which would make it the same as =)

You might want to take into account case sensitivity as well by using UPPER() or LOWER() on both sides of the operator.

e.g. UPPER('%text%')

<div>
I know the SQL-Syntax for the LIKE-operator. My problem is the interface to setup the view. Or to be more specific the arguments of the view. There is no option to change the &quot;=&quot; to LIKE. <br />
<br />
So the problem is not solved :(
</div>


I know the SQL-Syntax for the LIKE-operator. My problem is the interface to setup the view. Or to be more specific the arguments of the view. There is no option to change the "=" to LIKE.

So the problem is not solved :(

<div>
<div class="content wysiwyg-content">
Hi.<br />
When using arguments in views of drupal I can implement some kind of filters.<br />
E.g.: Get only nodes with specific title.<br />
The generated SQL query uses a &quot;=&quot; (equal) operator. So the user has to enter the exact title he is looking for. I want to change the &quot;=&quot; to the LIKE-operator. But I have no clue how to do so.<br />
Any ideas?<br />
<br />
Thanks in advance.<br />
Simon 
</div>
</div>


Hi.
When using arguments in views of drupal I can implement some kind of filters.
E.g.: Get only nodes with specific title.
The generated SQL query uses a "=" (equal) operator. So the user has to enter the exact title he is looking for. I want to change the "=" to the LIKE-operator. But I have no clue how to do so.
Any ideas?

Thanks in advance.
Simon 

Howto: LIKE statement in views arguments?

Drupal is an open-source content-management framework written in PHP used as a back-end framework for websites and is also used for knowledge management and business collaboration. The standard release of Drupal contains basic features common to content management systems, including user account registration and maintenance, menu management, RSS feeds, taxonomy, page layout customization, and system administration. Drupal runs on any computing platform that supports both a Web server capable of running PHP and a database to store content and configuration.

Drupal

A web-based content management system (CMS) provides website authoring, collaboration, and administration tools that enables users with little knowledge or experience to create and manage website content. Most CMS systems use a content repository or a database to store page content, metadata, and other information assets, and a presentation component that displays the content to website visitors.