Simple SUBSTRING (the SQL version)

[aaron_karp]

I'm trying to select only the rows where the first 10 letters are "processing" but I can't seem to get SUBSTRING to work right by looking at the manual and past threads.

	  $sql = "SELECT * FROM users WHERE (SUBSTRING(status, 0, 10) = 'processing')";
	  $result = mysql_query($sql);
	  echo mysql_num_rows($result);

That keeps returning 0 rows...am I doing it right?

Thanks.

[LordShryku]

Why not just use a wildcard?

SELECT * 
  FROM users 
 WHERE status LIKE 'processing%'

[aaron_karp]

That would work. And actually I just resolved it - it should be 1,11 not 0,10

[aaron_karp]

And thanks, by the way =)

[aaron_karp]

Bah, 1,10