On Saturday, May 7, 2016, Dev Mukherjee <[email protected]> wrote: > >> >> > If I create the full text and include multiple fields in the index > > CREATE FULLTEXT INDEX `keyword_search` ON > customer(name,physical_address_street,physical_address_suburb, > physical_address_state,physical_address_post_code); > > I can only execute a search with the same set of fields > > SELECT * FROM customer WHERE > > MATCH(name,physical_address_street,physical_address_suburb,physical_address_state, > physical_address_post_code) AGAINST ("+Anomaly" IN BOOLEAN MODE); > > If I try this in SQLAlchemy > > session.query(Customer).filter(Customer.name.match("+Anomaly"), > Customer.physical_address_street.match("+Anomaly"),Customer.physical_address_suburb.match("+Anomaly"),Customer.physical_address_state.match("+Anomaly"),Customer.physical_address_post_code.match("+Anomaly")).all() > > MySQL complains about no matching column list for Full text search. > > Is is possible to express multiple fields in the match operator? Or should > I not be creating a full text index amongst multiple fields? >
Right that *is* the use case that the stack overflow answer is meant for. I can accept pull requests that add a new mysql.match() object for this purpose. But it might be nice if it integrates with the FULLTEXT DDL part of it as well. This is all very simple to implement it's just coming up with a great API that supports all the edge cases that has to be done carefully. > > PS for my use case I want to search against all the fields. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','sqlalchemy%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
