Query to limit search to portion of column

[Rasiel Suarez]

Hi, I'm brand-spanking-new to MySQL and learning via phpmyadmin.

I want to match a text string in a column but want to limit the searchspace to the first say 100 characters. Currently I'm using a query in this form:

SELECT * FROM tablename WHERE textcol LIKE '%searchstring%';

I'm guessing I have to use CONCAT but not sure

Thanks!

Ras