search

DotNetNext / SqlSugar

.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
https://www.donet5.com/Home/Doc
MIT License
5.19k stars 1.32k forks source link

mysql 全文索引 #1183

Closed linjiaen closed 10 months ago

linjiaen commented 11 months ago

请问有实现mysql 全文索引语法吗 还是要自己先原生语句

DotNetNext commented 11 months ago

可以用扩展函数实现， 也可以用局部SQL .Where("MATCH(title, description) AGAINST('apple')").ToList()

DotNetNext commented 10 months ago

SqlSugarCore 5.1.4.103-preview14 支持了全文索引函数

db.Queryable<Order>().Where(x => SqlFunc.FullTextContains(x.Name, "a")).ToList()

如果创建全文索引因为太过复杂暂技术问题支持会比较麻烦需自已创建

DotNetNext commented 10 months ago

还有疑问发新的issue