Number from Left

[raouleduke]

I want to find all records with a specific character 8 spaces from the left, any idea how I do this.

[jrolands]

how about something like this

$result = mysql_query("SELECT * FROM table WHERE column LIKE '_______".$char."%'");

Take a look here http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_like