Advertisements

Archive

Posts Tagged ‘like cllause’

How to use Variable in MySQL Like Clause ?

October 24, 2018 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!

 

Advertisements
Categories: Sql Server Tags: , ,