Question: I'm trying to select rows which contains a specific number after current date.

My code looks like this:

```
SELECT *
FROM MyTableName
WHERE ( _001 ) AND My Date Column > todays date
LIKE '%2%'

```

I'm looking for the number 2 in \_001.
"My Date Column" is describing the date linked the row.

Answer: 
you can use `SUBSTR` function for it, like this - 
`SELECT * FROM MyTableName WHERE SUBSTR(your-date-col,0,1) = '2' AND your-date-col > CURDATE()`
use MySQL `CURDATE()`

```
Date > CURDATE() //return current date

```

or try this query :-

```
SELECT *
FROM MyTableName
WHERE ( _001 ) AND date > CURDATE()
LIKE '%2%'

```