I mean for the LIKE clause.. so what happens is if you do t.column LIKE '%$searchTerm%'; this will check for the search term within the content of the column.
The dql rules are the same as the sql rules if you want to check that out on mysql.com On Fri, Nov 5, 2010 at 18:31, xpanshun <[email protected]> wrote: > Isn't that for when you want to go through all of the columns in the > database? I only wanted to look through the particular ones above... > > On Nov 5, 6:01 pm, Alex Pilon <[email protected]> wrote: > > You need to use wildcards > > > > On Nov 5, 2010 5:55 PM, "xpanshun" <[email protected]> wrote: > > > > Hi everyone, > > > > I am trying to return any record from the database where a certain > > word (stored in variable $searchterm) is used (within a few different > > fields)... > > > > Here is what I have: > > > > $q = Doctrine_Query::create() > > ->from('Product p') > > ->where('p.product_id = ?', $search_term) > > ->orWhere('p.product_full_desc LIKE ?', $search_term) > > ->orWhere('p.product_partial_desc LIKE ?', $search_term) > > ->orWhere('p.product_type = ?', $search_term); > > > > $result_array_searchresults = $q->fetchArray(); > > > > However the only field that I can get a return from is a one-word > > field like 'bracelet'. Fields like 'product_full_desc' or > > 'product_partial_desc' that contain strings/sentences won't return > > anything. I want the query to be able to read through these strings > > and pick out the search term. > > > > What is wrong with my query? How can I achieve the result I want? > > > > Thanks! > > > > -- > > If you want to report a vulnerability issue on symfony, please send it to > > security at symfony-project.com > > > > You received this message because you are subscribed to the Google > > Groups "symfony users" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected]<symfony-users%[email protected]> > <symfony-users%2bunsubscr...@goog legroups.com> > > For more options, visit this group athttp:// > groups.google.com/group/symfony-users?hl=en > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony users" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en > -- Alex Pilon (613) 608-1480 -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
