how do i go about using Mysql variables inside... Mysql regex?
for example,
SET @my_var = (
SELECT
year
FROM blah
LIMIT 1);
SELECT
foo,
bar
FROM my_table
WHERE date REGEXP @my_var%
also tried... WHERE date REGEXP '@my_var%'
what i'm trying to do is... WHERE date REGEXP '2015%'
You would use concat:
where col regexp concat(@my_var, '%')
But two things:
LIKE pattern than a REGEXP pattern.LIKE or REGEXP for dates. MySQL has many useful date functions.So, I think you want:
where year(date) = 2015
or:
where date >= '2015-01-01' and date < '2016-01-01'
The last version is preferred because it can take advantage of an index, if available.
Another way, depending on how organized you want to be...
SET @var = 101;
SET @regex = concat("^",@var,"$");
SELECT * FROM db.table
WHERE col REGEXP @regex;
