like cllause | Rahul's space

How to use Variable in MySQL Like Clause ?

October 24, 2018 Rahul Bhatia Leave a comment

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!

	Mehdi Bennis on AngularJS With Asp.net Web API…
	hnc24 on Send Email from a Static …
	Rob on Send Email from a Static …
	Amol Kumbhkarna on Understanding asp.net MVC (Mod…
	Amol Kumbhkarna on MVC: From where to find System…