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 (104)
- 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
- MYSQL : How to skip first 10 records from a SELECT query and take next 10?
- How to compile .NET Core Console Application as .exe File?
- ASP.NET Routing with IIS 7 (runallmanagedmodulesforallrequests = true)
- How to Collapse all #regions only(!) in C# (Visual Studio)
- MySQL : The user specified as a definer ('root'@'%') does not exist
- Kendo grid error : kendo.all.min.js:12 Uncaught TypeError: e.slice is not a function
- UpdatePanel and triggers from a repeater control
- Call Repeater ItemCommand event manually from outside the repeater
- USAePay Token error: 23 Specified source key not found
- Disable click outside of bootstrap model area to close modal
Recent Posts
- How to compile .NET Core Console Application as .exe File?
- 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
Blog Stats
- 155,867 hits
Rahul Bhatia
Profile
Blog Stats
- 155,867 hits
Comments