Home
> Sql Server > How to use Variable in MySQL Like Clause ?
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
like cllause, MySQL, SQL
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Comments