Fulltext query in MySQL with TypeORM

I do not have much experience with mysql fulltext. But my simple test is running.

Entity:

@Entity()
export class User {

    @PrimaryGeneratedColumn()
    id: number;

    @Index({ fulltext: true })
    @Column("varchar")
    name: string;

    @Index({ fulltext: true })
    @Column("varchar")
    lastname: string;

    @Index({ fulltext: true })
    @Column("text")
    personalDescription: string;
}

Select using query builder:

const searchTerm = "programmer";

const result = await connection.manager.getRepository(User)
            .createQueryBuilder()
            .select()
            .where(`MATCH(lastname) AGAINST ('${searchTerm}' IN BOOLEAN MODE)`)
            .orWhere(`MATCH(name) AGAINST ('${searchTerm}' IN BOOLEAN MODE)`)
            .orWhere(`MATCH(personalDescription) AGAINST ('${searchTerm}' IN BOOLEAN MODE)`)
            .getMany();

If you need more advanced fulltext search you have to check mysql documentation.

You should write find like this:

const result = await connection.manager.getRepository(User).find({
   where: [{
        lastname: Like("%programmer%")
   }, {
        name: Like("%programmer%")
   }, {
        personalDescription: Like("%programmer%")
   }]
});

This is just simple example with LIKE.

I do not have experience with mysql fulltext feature, but if you want to use it you have to define fulltext index with @Index({ fulltext: true }) and use query builder to write own custom query http://typeorm.io/#/select-query-builder/adding-where-expression and use special sql syntax.