Archive
Posts Tagged ‘like cllause’
How to use Variable in MySQL Like Clause ?
Here is an example to use SQL variable in the mysql select query like clause
SET @name = 'advancewebsoftware';
SELECT * from `user` WHERE name LIKE CONCAT('%', @name, '%');Hope this help!
Categories: Sql Server
Tags: like cllause, MySQL, SQL
Categories
- AngularJs (13)
- ASP.NET (103)
- C Programming (1)
- Code Project (2)
- CodeProject (1)
- Entity Framework (6)
- Ext.NEt (1)
- HTML5 (1)
- Interview .NET (2)
- Introduction (1)
- JQuery (1)
- Linq (1)
- Microsoft office (2)
- MOSS-(Sharepoint 2010) (2)
- MVC (5)
- Outlook (1)
- Sql Server (30)
- SSRS (5)
- TFS (1)
- Tips & Tricks (16)
- Twitter bootstrap (1)
- VB.NET (1)
- Visual Studio 2012/2013 (1)
- Web Services (1)
- Windows Workflow (1)
Top Posts & Pages
- GridView: Findcontrol from HeaderTemplate/ItemTemplate
- Entity Framework : Could not load type System.Data.Entity.Design.AspNet.EntityDesignerBuildProvider
- MySQL : The user specified as a definer ('root'@'%') does not exist
- Call Repeater ItemCommand event manually from outside the repeater
- MYSQL : How to skip first 10 records from a SELECT query and take next 10?
- hide img tag if src is empty but without javascript/jQuery or css3
- Disable click outside of bootstrap model area to close modal
- Send Email from a Static HTML
- Error :(System.Web.UI.HtmlControls.HtmlIframe) is not compatible with the type of control (System.Web.UI.HtmlControls.HtmlGenericControl) in VS2017
- Define Composite Key in Model.(Core, EF Code First)
Recent Posts
- Define Composite Key in Model.(Core, EF Code First)
- How to remove x from Internet Explorer ?
- The client and server cannot communicate, because they do not possess a common algorithm
- How to check if all items are the same in a list C#
- How to Collapse all #regions only(!) in C# (Visual Studio)
- Issue: Password field returned empty in edit mode
- Load XML from URL giving an error (The remote server returned an error: (401) Unauthorized.)
- How to use Variable in MySQL Like Clause ?
- Error :(System.Web.UI.HtmlControls.HtmlIframe) is not compatible with the type of control (System.Web.UI.HtmlControls.HtmlGenericControl) in VS2017
- MySQL : The user specified as a definer (‘root’@’%’) does not exist
Blog Stats
- 153,594 hits
Profile
Blog Stats
- 153,594 hits
Comments