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!
Advertisements
Categories: Sql Server
Tags: like cllause, MySQL, SQL
Advertisements
Categories
- AngularJs (13)
- ASP.NET (101)
- C Programming (1)
- Code Project (2)
- CodeProject (1)
- Entity Framework (5)
- 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 (15)
- Twitter bootstrap (1)
- VB.NET (1)
- Visual Studio 2012/2013 (1)
- Web Services (1)
- Windows Workflow (1)
Top Posts & Pages
- The file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.
- Kendo grid error : kendo.all.min.js:12 Uncaught TypeError: e.slice is not a function
- MYSQL : How to skip first 10 records from a SELECT query and take next 10?
- COALESCE with DISTINCT in SQLServer
- MySQL : The host localhost does not support SSL connections
- Disable right click on web page and images
- Disable click outside of bootstrap model area to close modal
- Entity Framework : Could not load type System.Data.Entity.Design.AspNet.EntityDesignerBuildProvider
- How to launch Bootstrap modal on page load
- Can not find ConfigurationManager class in class library C#
Recent Posts
- 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
- MySQL : The host localhost does not support SSL connections
- How to Add space and increase width of Morris.Js Bar?
- How to fix function is ambiguous in the namespace ‘system’ compiler error
Blog Stats
- 142,618 hits
Profile
Blog Stats
- 142,618 hits
Advertisements
Comments