Specify variable in a MySQL query

Question

probably been asked before but I couldn't find an answer.

Is it possible to specify a user defined variable in a mySQL query. Such as:

select * from table where column like "%MYVAR%" or column like "%MYVAR%"

Basically, it would be a bit more complicated than that but if I wanted to use the same text multiple times how could I set this and reuse it?

Many thanks.

What is meant by user defined variable?

Awais Qarni
– Awais Qarni

2011-10-14 10:21:37 +00:00
Commented Oct 14, 2011 at 10:21 — Awais Qarni
– Awais Qarni, Commented Oct 14, 2011 at 10:21

Devart · Accepted Answer · 2011-10-14 10:28:37Z

5

It is possible -

SET @var1 = 'table%';
SELECT * FROM table1 WHERE column1 LIKE @var1;

More information - User-Defined Variables.

answered Oct 14, 2011 at 10:28

Devart

120k23 gold badges171 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tim Cutting Over a year ago

Thank you for that. In SQLyog I have to run the SET command first and then, separately, run the query (using 2 different query windows). Can this be done from the same query window? Not essential, but would cut a few clicks out.

Devart Over a year ago

You can do it in dbForge Studio for MySQL (free express edition) - devart.com/dbforge/mysql/studio

Awais Qarni · Accepted Answer · 2011-10-14 10:35:18Z

0

To get this working, you should use stored procedure. Check Documentation

edited Oct 14, 2011 at 10:35

Awais Qarni

18k25 gold badges80 silver badges144 bronze badges

answered Oct 14, 2011 at 10:19

ivatanako

133 bronze badges

Collectives™ on Stack Overflow

Specify variable in a MySQL query

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related