将SQL转换为mysql语句以在C#中使用 [英] Convert sql to mysql statement to use in c#

问题描述

任何人都可以将其转换为有效的mysql语句

Can anyone convert this to a mysql statement that works

select * from dbo.T_Recipients where Company_Name = 'ACSA' and User_Name = 'Arend' and Full_Name like '%A%'

推荐答案

select * 
from T_Recipients 
where Company_Name = 'ACSA' 
and User_Name = 'Arend' 
and Full_Name like '%A%';

Hello Divan，

首先，您应该阅读以下链接:

http://dev.mysql.com/doc/refman/5.0/en/pattern- matching.html [^ ]

问候
sarva

Hello Divan,

first you should read this link:

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html[^]

regards
sarva

这篇关于将SQL转换为mysql语句以在C#中使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！